Backup of SQL database fails with error "It is acting as a mirror database."

Problem

Backup of SQL database fails with error "It is acting as a mirror database."

Error Message

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.






Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)