Database mirroring maintains two copies of a single database that must reside on different server instances of SQL Server Database Engine.
When the mirror is removed from the Primary database the mirrored one sometimes doesn't recover and it says "Recovering".
If the database doesn't leave this state, the following TSQL command can help:
RESTORE DATABASE myDatabase WITH RECOVERY
This will allow to recover the former mirror database.
No comments:
Post a Comment