How to change the SQL state from normal to restore state
Posted on 2010-11-08
I have 2 SQL 2008 servers setup on a mirror with no witness, due to a fail-over the main server was demoted and the backup server set as the Principal.
The hardware issue was resolved and the main server is now back on and I reactivated the mirror with the backup server as the Principal and the main as the mirror. I need to reverse the Roles as the Main server has extra applications and more robust hardware, my question is how can I quickly change the principal to the restore mode?
I use the following command to take the server from restore state to active state but I dont want to have to do a restore with NORECOVERY I would like to use a script like the below to do this
ALTER DATABASE DBData SET PARTNER OFF
RESTORE DATABASE DBData WITH RECOVERY
is there a reverse of this statements that will achieve what I need?