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
Article Type
Technical Solution

Product(s)

Environment

Issue



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.






Supplemental Materials

SourceError Code
Value0xe0008443
DescriptionOne or more SQL Database consistency checks have failed.


Legacy ID



319211


Article URL http://www.symantec.com/docs/TECH67641


Terms of use for this information are found in Legal Notices