Home Forums SQL Server 2008 SQL Server 2008 High Availability database mirroring witness and client redirect RE: database mirroring witness and client redirect

  • May 1, 2013 at 9:55 am

    #1611635

    george sibbald (5/1/2013)

    Lynn - I would not ask such a newbie question.

    I know how the databases fail over, automatically or not, I was just looking for a second opinion on the conditions required for the client to automatically redirect when the database has swapped roles.

    I believe the witness is not required for CLIENT redirect - anyone out there have second opinions on that?

    You are correct, the witness is not needed for the client, but it is needed for an automatic failover. The client, in fact, never communicates with the witness.