Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

How would one start the secondary mirror instance if the principal SQL server instance went off line?

share|improve this question

1 Answer

up vote 2 down vote accepted

I'm assuming you don't have automatic failover and no witness, otherwise the mirror would have been promoted automatically.

In this case you need to switch the roles manually, with forced service:

ALTER DATABASE database_name SET PARTNER FORCE_SERVICE_DATA_LOSS

See Role Switching During a Database Mirroring Session
and ALTER DATABASE Database Mirroring for more detail.

share|improve this answer
Correct we don't have automatic fail over with a witness. Can you run that command on a database that is in a restoring state? – davey Feb 1 at 16:31
That's what it was made for. – spaghettidba Feb 1 at 16:34

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.