Not able to run ALTER DATABASE [DatabaseNameHere] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE On Azure

Asked Nov 15 '18 at 16:02

Active Nov 15 '18 at 18:18

Viewed 2,058 times

I have created SQL Database on Azure SQL server service, and trying to enabled Service Broker, but getting below Error.

Error :The operation cannot be performed on database "DatabaseNameHere" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

edited Nov 15 '18 at 18:18

asked Nov 15 '18 at 16:02

Nilesh Mohite

Follow the steps here: http://www.sqlnuggets.com/blog/change-the-isolation-level-of-an-availability-group-database/ – Eray Balkanli Nov 15 '18 at 16:06
Thanks Eray! please let me know, How to get AVAILABILITY GROUP – Nilesh Mohite Nov 15 '18 at 16:28

Not able to run ALTER DATABASE [DatabaseNameHere] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE On Azure

0 Answers0