MissTippsInOz (2/13/2013)
HiI'm currently running some DR testing and have failed over a couple of databases to our DR site. Generally the process was:
Tail log backup on ServerA with NORECOVERY
RESTORE with RECOVERY on ServerB
Correct up to and including this point. When failing over Log Shipping scenarios, consult the following documentation
http://msdn.microsoft.com/en-us/library/ms178117(v=sql.105).aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉