Skip to main content
NetApp Knowledge Base

Secondary database migration fails

Views:
49
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

·        SnapCenter Plug-in for Microsoft SQL Server

Issue

Migration of the secondary replica of an Availability Group (AG) database fails with error:

System.Data.SqlClient.SqlError: Log backup for database "DBSDML" on a secondary replica failed because a synchronization point could not be established on the primary database. Either locks could not be acquired on the primary database or the database is not operating as part of the availability replica. Check the database status in the SQL Server error log of the server instance that is hosting the current primary replica. If the primary database is participating in the availability group, retry the operation.

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support