Hafiz Suleman's Blog
Monday, January 24, 2011
Recovering the mirror DB when Principal DB fails in sql server
When principal db is non-operational and fully inaccessible then following commnd needs to run on mirror DB to recover it.
USE MASTER
ALTER DATABASE [MirrodDB_Name] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment