A backup job for Microsoft SQL database which include both nodes of the mirrored SQL Server may fail with ' The database "name" cannot be opened. It is acting as a mirror database '
Article ID: 100001477
Updated On:
Description
Error Message
A backup job for Microsoft SQL database which include both nodes of the mirrored SQL Server may fail reporting the following error in the job log :
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors
For additional information regarding this error refer to link V-79-57344-33938
Backup -
V-79-65323-954 - An error occurred on a query to database
V-79-65323-954 - The database "
Cause
The SQL agent supports a mirrored SQL database configuration, although Microsoft places limitations on the mirroring of SQL databases and one of the limitation is that a mirrored SQL database cannot be backed up or restored causing the job to fail.
Resolution
Try to backup SQL database from under primary database server in the backup job selection list.
Issue/Introduction
A backup job for Microsoft SQL database which include both nodes of the mirrored SQL Server may fail with ' The database "" cannot be opened. It is acting as a mirror database '
Was this article helpful?
Yes
No
Powered by
