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.