How can do manual failover in mirroring??

Question

How can we do manual failover in mirroring??i know that mirroring is a automatic failover..

---

Sivamanikanta. P

Answer 1

connect to the Principal Server and initiate the following command:

USE [master];
GO
ALTER DATABASE [TestDB] SET PARTNER FAILOVER;
GO

For more info, check the following post from Books  Online : http://msdn.microsoft.com/en-us/library/ms179481.aspx

---

SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)

Answer 2

Hello,

Check this article 

Manually Failover a database mirroring session

http://msdn.microsoft.com/en-us/library/ms186348.aspx

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 3

Two ways -

1. Principal available - Run below command on principal 

  ALTER DATABASE dbName SET PARTNER FAILOVER

2. Principal not available  - Run below command on mirroring

ALTER DATABASE dbName SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

---

http://uk.linkedin.com/in/ramjaddu