SQL Server Mirroring

SQL Server Mirroring Related Queries:

How do I swap Primary and Secondary on Mirroring Databases ?
When the automatic failover is setup , the Primary / Secondary gets swapped during maintenance tasks.
To swap back the Primary/Secondary , connect to the server which’s primary and run the following command.

Mirroring Databases and the Status:

Restoring a Database which is involved in Mirroring Session

Caveats:

You cannot restore a database that is involved in Mirroring without breaking/removing Mirroring.
Backup and restore of the mirror database are not allowed.
Backup of the principal database is allowed, but BACKUP LOG WITH NORECOVERY is not allowed.
Restoring the principal database is not allowed.

References:
https://technet.microsoft.com/en-us/library/ms191235(v=SQL.105).aspx

Leave a Reply

Your email address will not be published. Required fields are marked *

*