up vote 0 down vote favorite
share [g+] share [fb]

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

link|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
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.