Answered by:
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
Friday, May 4, 2012 1:15 PM
Answers
-
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
- Proposed as answer by amber zhang Monday, May 7, 2012 2:12 AM
- Marked as answer by amber zhang Friday, May 11, 2012 8:48 AM
Friday, May 4, 2012 4:43 PM
All replies
-
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)
- Edited by Sudeepta Ganguly Friday, May 4, 2012 1:31 PM add info
Friday, May 4, 2012 1:30 PM -
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 youFriday, May 4, 2012 1:49 PM -
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
- Proposed as answer by amber zhang Monday, May 7, 2012 2:12 AM
- Marked as answer by amber zhang Friday, May 11, 2012 8:48 AM
Friday, May 4, 2012 4:43 PM