Post reply

Mirroring

  • March 16, 2011 at 7:22 am

    #236411

    i dont have experience in mirroring , can any one pls clarify this ?

    I have 3 servers configured in mirroring .when the principle database is crashed , how can we make the mirroring to live ?

    can we shrink the log file in mirroring ?

  • March 16, 2011 at 7:35 am

    #1299356

    That depends what mode your mirroring is running in and whether or not you have a witness server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 16, 2011 at 7:47 am

    #1299368

    its running under high availability mode and a mirror server exists and if not a mirror ?

  • March 16, 2011 at 10:39 am

    #1299491

    Huh?

    Synchronous or asynchronous? Do you have a witness server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 17, 2011 at 5:31 am

    #1299871

    its running under synchronous , witness is there

  • March 17, 2011 at 6:00 am

    #1299882

    Then you have auto failover. If the principal fails, the mirror will come online automatically. If client apps are using SNAC, they will redirect automatically as well

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 18, 2011 at 1:26 pm

    #1300770

    Gail,

    Just curious, what does SNAC stand for?

    Thanks,

  • March 18, 2011 at 2:03 pm

    #1300794

    SQL Native Access Client.

    Google works, but the search terms aren't maybe the most intuitive

    http://www.google.com/search?q=SNAC+SQL+Server

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 18, 2011 at 2:36 pm

    #1300807

    Thanks,

    You are right- Goggle search for SNAC returned a lot of funny stuff.

    We actually used probably something similar- Sql Server Native Client OLEDB provider-

    simply add "Failover_Partner" (for mirror DB) keyword for Connection String. Need to read a bit regarding this SNAC. Thanks again

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply