Home Forums SQL Server 2008 SQL Server 2008 High Availability DB mirroring questions .. RE: DB mirroring questions ..

  • February 20, 2014 at 5:42 am

    #1690631

    Oracle_91 (2/19/2014)

    Hi LightVader,

    Thanks for the answer for scenario-1. I got to know the same thing from my peers. We need to break the mirroring and bring it online.

    use master

    go

    alter database <dbname> set partner off;

    go

    restore database <dbname> with recovery;

    go

    As long as you keep in mind that if you do it that way, when the principal and witness come back online, you will have to go through the whole mirroring setup process again.


    The opinions expressed herein are strictly personal and do not necessarily reflect the views or policies of my employer.