Skip to main content
NetApp Knowledge Base

SCSQL backup fails with error The target database is participating in an availability group

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

Applies to

  • SnapCenter Server (SC)
  • SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
  • Always-On Availability Group

Issue

SCSQL backup of an Always-On Availability Group (AG) fails with the error seen in the Job details in the SC UI:

Activity - Freeze database(s), Completed with warning : Resource (<resource\database>) failed with error
(Failed to backup database [<database_name>]. Error: The target database, '<database_name>', is participating in an availability group and is currently not accessible for queries.
Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability
replicas in the group.  For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.

 

 

 

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