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