Post reply

Enable back Database Mirroring

  • April 8, 2013 at 10:34 pm

    #291930

    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 9, 2013 at 5:51 am

    #1604773

    You need to restore the princple database and log to the mirror db to get them back in sync(with noecovery). You can then re-establish the mirror session.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply