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

Legacy Scale
1

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

2

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.
Cam

3

Ok thanks

/aage