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

Enable back DB Mirroring Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 10:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 2:17 AM
Points: 8, Visits: 41
Hi Everyone,

I Have disabled database mirroring on principal server using below command for restoring database over a mirrored database because it was not allowing me to restore.

ALTER DATABASE AdventureWorks2012 SET PARTNER OFF;

after executing above command i was able to restore the database , now i want to enable back database mirroring
can some please help me with the steps.

Thank you in advance for looking into my post.
Post #1440138
Posted Wednesday, April 10, 2013 8:07 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 2, 2014 6:57 PM
Points: 2,317, Visits: 1,362
You will need to re-setup mirroring from scratch. Restore the database and transaction logs to the mirror with NORECOVERY then setup mirroring under the mirroring tab of the database properties for the principal database.
Post #1440825
Posted Thursday, April 11, 2013 4:25 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 12:53 PM
Points: 424, Visits: 1,567
Just did this yesterday night, i.e. break/restore Mirror:
1. restore Full backup with NoRecovery
2. restore all sequential TrLog backups with NoRecovery
3. setup partners on Principal and Mirror to point to each other:
ALTER DATABSE DB_Name SET PARTNER = PRT_Name
4. At this moment Mirror session should start automatically
5. Change Safety Mode if not High Safety (defualt)
Post #1441513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse