How would one start the secondary mirror instance if the principal SQL server instance went off line?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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:
See Role Switching During a Database Mirroring Session