Home Forums SQL Server 2008 SQL Server 2008 Administration Manually failing over a mirror without access to Primary Server RE: Manually failing over a mirror without access to Primary Server<!-- 864 -->

  • August 21, 2014 at 11:19 am

    #1739985

    On another note, I recently found that I can also just break the mirror from either the primary or the secondary as per this BOL note. So it all depends on whether or not I want to just set the failover or break the mirror entirely.

    Breaking the mirror seems a little last resort to me, though.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.