Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have 2 db's that have been happily mirroring each other for months. Today both DB entered the state (principle, disconnected). I am unable to stop the principle(db1) from mirroring.

Error

Msg 1404, Level 16, State 6, Line 1 The command failed because the database mirror is busy. Reissue the command later.

When using the command

ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Thanks for any help Sp

share|improve this question
    
What information is in the ERRORLOG? –  mrdenny Jan 27 '11 at 17:42
    
There's always the option (easy for me to say, right?) of stopping #2, rebooting #1, and then seeing if you are able to stop the mirroring of your principle. –  jl. Jan 27 '11 at 18:29
    
I stoppped and started the SQL service, which caused the DB to go into recovery mode. After about 15 mins of down time (and the boss going mental at me) I ran ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS which took the DB out of recovery. I was then able to re sync the mirror...Phewwww –  Steven Jan 28 '11 at 13:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.