Backup of SQL database fails with error "It is acting as a mirror database."
| Article:TECH67641 | | | Created: 2009-01-09 | | | Updated: 2010-01-17 | | | Article URL http://www.symantec.com/docs/TECH67641 |
Problem
Backup of SQL database fails with error "It is acting as a mirror database."
Error
Backup- An error occurred on a query to database "Database Name"- The database "Database Name" cannot be opened. It is acting as a mirror database.
Solution
Database mirroring involves two copies of a single database
that typically reside on different computers. At any given time, only one copy
of the database is currently available to clients. This copy is known as the
principal database. Updates made by clients to the principal database are
applied on the other copy of the database, known as the mirror
database.
An attempt to backup the database from mirror database the backup job fails and gives error as shown in figure below.
Solution:
Deselect the databases from the Mirror Database Server and back them up from the Principal Database Server.
An attempt to backup the database from mirror database the backup job fails and gives error as shown in figure below.
Solution:
Deselect the databases from the Mirror Database Server and back them up from the Principal Database Server.
|
|
| Source | Error Code |
| Value | 0xe0008443 |
| Description | One or more SQL Database consistency checks have failed. |
Related Articles
Legacy ID
319211
Article URL http://www.symantec.com/docs/TECH67641
Terms of use for this information are found in Legal Notices
Thank you.