Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server DR testing using XIV SAN replication.

Posted on 2011-02-14
1
Medium Priority
?
765 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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

670 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