Skip to main content

Hi,

I tried to use the use the data sensitivity function in the SF. However, it returned several errors. The initial error in the SF indicated that the database is not in single-user mode. Consequently, I tried to upgrade the database, yet encountered another error similar to the one below. It is an Azure SQL database. What steps can I take to enable single-user mode?

 

Hi,

It looks like the database you want to anonymize is located in an AlwaysOn availablity group and/or is placed in a High-availability & Database recovery Azure SQL Server VM. Or that the database makes use of Database mirroring.

You probably need to turn HADR off: ALTER DATABASE SET HADR (Transact-SQL) - SQL Server | Microsoft Learn. There are a couple of limitations to it such as it only being supported on secondary replicas. 

Hope this helps!


Hi @groos, did Mark his reaction help you out?