I have an Azure SQL Server database with a Geo-replication on Azure, which I would like to regularly backup via
sqlpackage.exe (s. command below) using the replicated read-only database.
However, when executing it, it runs into an error (SQL71501) - the error occurs both on the primary as on the secondary database.
As this is a production database with thousands of users, is there any way to fix that in an "open heart surgery", i. e. without taking down the service, copying the database, fixing stuff then deploying that as the life database?
The command I run:
sqlpackage.exe" /a:Export /scs:"Data Source=tcp:xxx.database.windows.net;Authentication=Active Directory Password;Initial Catalog=xxx_Copy;UID=xxx;PWD=xxx" /tf:C:\Databases\xxx-$(((get-date).ToUniversalTime()).ToString("yyyy-MM-dd-T-HH_mm_ss")).bacpac
The result I get:
Error exporting database:One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element [dss]: Schema: [dss] has an unresolved reference to object [##MS_SyncAccount##].
Error SQL71501: Error validating element [TaskHosting]: Schema: [TaskHosting] has an unresolved reference to object [##MS_SyncAccount##].