Solved

SQL Server DR testing using XIV SAN replication.

Posted on 2011-02-14
1
764 Views
Last Modified: 2012-06-21
We are testing DR against SQL Server 2008 with XIV replication on our IBM SAN. The O/S, MSSQL, and data drives are all being replicated.  Our process includes setting up the replication, then shutting down the servers, assigning the mirrored LUNs to failover servers, and then booting up the failover servers.

Can anyone recommend a test against SQL Server that might break our system?

We have successfully tried online index rebuilds and normal index rebuilds.  High volume bulk inserts were also succussful.
0
Comment
Question by:lundnak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 35242781
What's the lag time on your replication? The only concern I'd have is that a transaction may have been committed to disk on the primary SQL Server, but then when you boot up the server attached to the mirrored LUN segments, it's in a different commit state, since things haven't been fully replicated over yet. If your servers are located in the same physical datacenter, you may want to consider Windows Clustering as a failover option - the two servers share a single set of LUNs and the OS handles who is in control and responding to client requests.

Other than that, your system sounds like it will work, and the replication lag is the only thing I can think of that would jeapordize the stability of your system. If your server is in production already, then your ability to simulate a failure is limited, but you can try cutting the network connection to your standby server as soon as a very large transaction commits in your primary server (but before replication is likely to be complete), and then attempt to fire it up and see what the state of the data is.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question