+5Hi,
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?
Best answer by Mark Jongeling
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!
+23Hi,
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!
+8Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
