The Multifunctioning DBA

Sep 26 2011   1:27PM GMT

Another DR Test

Colin Smith Colin Smith Profile: Colin Smith

So we have what sounds to be a great idea for our SQL Server DR. We are doing block level replication between datacenters and so we thought it might be a good idea to joust mount up our disk on another server that is in the DR Datacenter in case of a disaster. We want to do that with the disk that holds all databases including the system databases. The thought is that if we build out the DR servers to look for the system DB’s in the same location as the prod server, once we bring that disk up and mount it to the DR servers we should be good and not have to worry about anything like, for example logins like we would have to with Mirroring.

So that is the thought and I am going to build out a couple servers in Virtual Box and try to test this out. Should be fun and simple enough to POC this idea. I will let you know more details on the test and if it works out or not.

Hope this might help

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: