SQL Server – How to restore the mirroring database

SQL, SQL-Advanced, Varinder Sandhu
SQL Server - Database Mirroring for Disaster-Recovery Solution

SQL Server – Database Mirroring for Disaster-Recovery Solution

Now here we have question regarding the Mirroring Database:

How can we recover the data from mirror database? How to restore the mirroring database?

Here I would like to clear that we cannot restore a database that is involved in Mirroring without removing Mirroring.

Removing the Mirroring using T-SQL 

ALTER DATABASE MirrorTest SET PARTNER OFF;

Restore the Mirror Database

RESTORE DATABASE MirrorTest WITH RECOVERY;

For Database Mirroring Administration click here

Related Posts

, ,