Post reply

Mirroring - Witness Server

  • May 5, 2008 at 5:28 pm

    #206961

    Hi,

    Hope this is the right forum for this. Just wanted to see if anyone had done this. has anyone used a witness server to witness multiple SQL 2005 mirrored instances? So I have different DBs mirrored on different mirrored instances but just the common witnes server.

    Any issues with performance? High Availability?

    Thanks in advance.

    Scott

  • May 6, 2008 at 1:35 am

    #811054

    Scott,

    Have a look at this link, http://msdn.microsoft.com/en-us/library/ms175191.aspx?PHPSESSID=6c7e47uec18v8n3121a6p001h4

    which describes about the role of witness server which facilitates automatic failover. You can have Sql Express or Workgroup as a witness server. But ensure that the witness server has the configurations similar as that of the principal server.

    [font="Verdana"]- Deepak[/font]

  • May 6, 2008 at 4:34 pm

    #811510

    Many Thanks Deepak, that answers my questions. Thanks mate.

Viewing 3 posts - 1 through 2 (of 2 total)

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