Solved

SQL Server DR testing using XIV SAN replication.

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
replicated - directional or bidirectional? 3 34
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 40
TSQL - How to declare table name 26 41
Sql query with where clause 2 33
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

789 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