how to enable back database 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.

  • The database and log of the principle database needs to be backed up and restored on the mirrored instance to get them in sync. Only then can the mirrored session be re-established.

  • Restore latest Full backup first and Transaction Log backup with RESTORE WITH NORECOVERY option (db should be in restoring mode).

    Then, start configuring DB Mirroring again.

    Hope this helps..!

    Cheers,
    - Win
    "Dont Judge a Book by its Cover"

  • here is a link to a set of instructions - http://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

    before setting it up though read up on the various operating modes and decide which you want and wether you will be using a witness server.

    I would suggest using the SQL service account to connect as well rather than sa.

    When setting it up script the set up out from the gui.

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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