Solved

SQL Server DR testing using XIV SAN replication.

Posted on 2011-02-14
1
758 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
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now