I've got log shipping running as part of my DR strategy and the recovery database shows up on the DR server in Standby / Read-Only mode. In the case of distaster how would I change the database from Standby mode into Normal mode?
The database is almost 10GBs and I'd like to test out a recovery while being able to then turn the database back into recovery mode after the test. Is that possible?
View Complete Post