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
‹
›
Home
View web version
No comments:
Post a Comment