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.
ALTER DATABASE [MirrodDB_Name] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;
Post a Comment
Post Comments (Atom)