Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

When you resume database mirroring Expand / Collapse
Author
Message
Posted Tuesday, July 5, 2011 5:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 6, 2011 2:27 PM
Points: 2, Visits: 5
In SQL Server 2008, if database mirroring breaks for some reason, and you want to resume mirroring with the principal again taking on the role of the principal after the mirroring temporarily served as principal, do you need to go back to square one? Meaning do you need to do full backup and t-log backup of the principal database and restore it on the mirror with no recovery? Or can you just run the below on the principal without without going back to square one:

Use Master;
GO
Alter Database MyDB Set Partner Resume;


I belive going back to square on would not be needed, and above command or simply click Resume in Database Properties > Mirroring Page.
Post #1136941
Posted Tuesday, July 5, 2011 8:22 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:03 PM
Points: 4,363, Visits: 9,547
It depends on what has happened on the principal after mirroring has been stopped. If you have a continuous log chain, then all you need to do is apply the transaction log backups to the mirror and restart mirroring.

If the log chain is broken, you have to reinitialize with a new backup and restore.

If the mirror is brought online, again - you have to start from the beginning again.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1136975
Posted Wednesday, July 6, 2011 11:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 6, 2011 2:27 PM
Points: 2, Visits: 5
Hi Mr. Williams,
You said if the mirror is brought online, I have start over. Do you mean if the mirror becomes a new principal via manual or automatic fail-over, and when I'm ready to fail-back to the original primary, then I will have to remove the mirroring, and reinitialize with the backup of the mirror (since it was promoted as the primary) and restore to the original primary? Is that correct?
Post #1137535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse