Forum Discussion
Solved
Unable to enable RCSI
We created our Azure SQL database few years ago and at that time RCSI was not a default setting. I am trying to enable RCSI now but unsuccessful. Database details: We have Azure SQL database (sing...
Yes, the replication was removed and reflected in the portal.
Instead of trying all the above steps, I just executed below one statement and RCSI is successfully enabled in primary database and successfully synced with secondary database as well.
ALTER DATABASE [DatabaseName] SET READ_COMMITTED_SNAPSHOT on WITH ROLLBACK IMMEDIATE
If you execute the REMOVE SECONDARY command, does the Geo-Replication settings in the Azure portal reflect that the replication link has been successfully terminated for the primary database?
It seems that when attempting to switch the primary database to SINGLE_USER mode, the service still perceives the replica as active, causing the operation to fail due to this constraint.