Upgrading fails with "....database mirroring session...."

ani's Avatar

ani

18 Dec, 2017 03:54 PM

We have recently upgraded from 3.1x to 4.1x but are facing issues with the Octopus Mssql db.

"The operation cannot be performed on database "DB_Octopus" because it is involved in a database mirroring session.
ALTER DATABASE statement failed."

We have been looking at http://www.sqlnuggets.com/blog/change-the-isolation-level-of-an-availability-group-database/ but is that really the way to do it ?

Best regards
Aage Nielsen
Openminds

  1. Support Staff 1 Posted by Cameron MacFarl... on 20 Dec, 2017 01:13 AM

    Cameron MacFarland's Avatar

    Hi Aage,

    Thanks for contacting us. Yes turning off mirroring, installing, and then turning mirroring back on is the way to go. This page from Microsoft says the same thing. https://blogs.msdn.microsoft.com/sqlcat/2010/03/16/how-to-enable-rc...

    Hope that helps.
    Cam

  2. 2 Posted by ani on 21 Dec, 2017 11:25 AM

    ani's Avatar

    Ok thanks

    /aage

  3. ani closed this discussion on 21 Dec, 2017 11:25 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac