SCSQL备份失败、并显示错误目标数据库正在加入可用性组
适用场景
- SnapCenter 服务器( SC )
- 适用于 Microsoft SQL Server 的 SnapCenter 插件( SCSQL )
- 无中断可用性组
问题描述
无中断可用性组(AG)的SCSQL备份失败、 并在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.