locked
Failover in mirror RRS feed

  • Question

  • I am trying to setup connection for a system using sql to failover to the mirror.

    I was given instructions to use  failover partner in my sql connection string

    If get a "Keyword not supported" in the event log

    I also tried   failoverpartner and failover_partner and all result with the same errro.

    Am I missing something or is there another keyword to use.

    Help is appreciated.

    Dave


    Dave Kozlowski

    Wednesday, May 14, 2014 4:06 PM

Answers

  • Failover Partner keyword not supported in .NET 1.0 or 1.1. 

    Can you check your .Net version? whats the sql version you are trying?

    Also, Can you post your connection string.

    string cs = @"Data Source=Server_A;Failover Partner=Server_B;Initial Catalog=MirroredDabase";

    Reference

    http://blogs.msdn.com/b/spike/archive/2010/12/08/clarification-on-the-failover-partner-in-the-connectionstring-in-database-mirror-setup.aspx

    --Prashanth

    Wednesday, May 14, 2014 7:04 PM