SQLTeam.com | Weblogs | Forums

Cannot perform Delete on the mirror DB

sql2012

#1

My mirroring was configured with transaction safety full on 2012 without witness.
Mirroring was removed from principle DB and the principle DB has been deleted. Now the mirror DB is showing as mirror/disconnected/ In recovery.
I'm not able to do anything (Delete/Restore) on the mirror DB. How to get the mirror DB restored?


#2

You can run this: RESTORE DATABASE dbnamegoeshere WITH RECOVERY