April 8, 2013 at 10:33 pm
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.
April 10, 2013 at 8:07 am
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.
April 11, 2013 at 4:25 pm
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)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply