Enable back DB Mirroring

  • 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.

  • 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.

  • 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