In this post i give a summary of what to do when mirrorring breaks down due to some reason. Here lets assume that the Principal is A and the Mirror is B.
Principal Lost
Safety Full With Witness
B is the new Principal now and the mirroring state is DISCONNECTED. When A becomes online, it resumes role as a Mirror automatically (ie we dont have to set up mirroring all over again) except that the session remains suspended until a resume command is issued in B (the new Principal). To do this run the following command in B (the new Principal).
ALTER DB SET PARTNER RESUME - no re-establishing required
Safety Full Without Witness
On mirror, execute the following
ALTER DB SET PARTNER OFF
RESTORE DB WITH RECOVERY
Then when A becomes online, re-establish mirroring
OR
ALTER DB SET PARTNER FORCE service_allow_data_loss ###
ALTER DB SET PARTNER RESUME - (no re-establishing required)
Safety Off
Same as ###
Mirror Lost
ALTER DB SET PARTNER OFF
Then re-establish the mirroring session.
1 comment:
Wow your blog sach me bahut hi lajawab hai mene adhi Jayada information apne collages ke project submit ki hai jisme ye batya gye hai compute course kitna jada benefir course hai computer ki jarurat har sector me padti hai or apko blog me article computer ke bare me maja a gye sach thanks you ese article submit karne ke liye
Graphic Designing course in Delhi NCR,
Best computer course in Delhi
Best Fine art Institute in Delhi
Post a Comment