question

Mandar Alawani avatar image
Mandar Alawani asked

DB mirroring - Manual failover with witness

Hi, Scenario: Server 1 : Principal Server 2 : Mirror Server 3 : Witness Mode: High-Performance (synchronous) Qs. 1 - As I understand, witness is used for automatic failover. However, in our scenario we do not want that to happen (due to some network restrictions) If witness is installed, both automatic failover is possible (initiated by witness itself) and manual failover (done from principal/mirror using SSMS or T-SQL). Is there a way to do ONLY manual failover using witness? i.e. Can we prevent automatic failover to happen even when witness is configured? According to me, this is not possible. Can someone please help clarify this? Thanks, Regards, Mandar
sql-server-2005database-mirroringfailover
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
The only reason to have a witness is to allow automatic failover - if you only want manual failover - remove the witness. Also note that having a witness in High-Performance is strongly advised against. See http://technet.microsoft.com/en-us/library/ms187110(v=sql.90).aspx
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You either want AUTO and need the Witness or you want MANUAL. No sense in adding unnecessary complexity to an environment.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.