Posted by: 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