October 4, 2010 at 1:02 am
Hi All,
I've successfully setup a manual SQL Mirror enviroment between 2 SQL 2008 servers. I'm testing failover between the servers. Through SSMS it works fine. I'm now testing a case where the principal server crashes. Below are the queries I used to bring the seconday or mirrored server online. This requires breaking the mirror between the 2 serves...I just wanted to confirm if this is the correct way of doing it.
ALTER DATABASE TestMirror
SET PARTNER off
USE MASTER
GO
RESTORE DATABASE TestMirror
WITH RECOVERY
Thanks
Denesh
October 4, 2010 at 7:36 am
yes those are the correct instructions to bring the mirror on-line. don't forget you may also have to change the database owner and re-synch userids.
You also have the option of force_service_allow_data_loss in this situation, but only if some data loss is acceptable and speed of recovery is tantamount. this also has advantages if when the old principal comes back online you want it to act as the mirror.
see http://msdn.microsoft.com/en-us/library/ms189977.aspx%5B/url%5D
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply