I have a set up where I have two SQL servers set up for failover mirroring to two other SQL servers.

I am not using a witness server.

I had previously used a witness server and that of course would automatically failover the databases when the primary would go down.

Now without using a witness database, how do you manually failover?

If I right-click the database on the mirror instance and click Tasks > Mirror, just get the database properties window, no option to "failover" or make the mirror the primary instance.

Of course if I do the same from the primary database I get the option to failover to the mirror but I obviously can't do this if the primary server is down.

Any ideas?


If my understanding is correct mirroring phase begin using restore database with norecovery option. So you should restore database with recovery

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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