May 5, 2008 at 5:28 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy