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

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

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-rcsi-for-a-database-with-database-mirroring/

Hope that helps.

Ok thanks