February 5, 2008 at 11:56 am
Is it possible to change the witness server after database mirroring has already been established without killing the mirror? If so, how? I'm a newbie as you can tell. Thanks.
February 5, 2008 at 6:45 pm
The Witness server is required in High availability mode and you cannot change the witness server to become the principal or mirror server. The Witness server forms a quorum with mirror server if the principal is down and makes the mirror as new principal.
You can read these links which might help you,
http://sql-articles.com/index.php?page=articles/dbmrr.htm
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
[font="Verdana"]- Deepak[/font]
February 5, 2008 at 11:32 pm
Yes - on the principal just do ALTER DATABASE yourdb SET WITNESS OFF to move down into high-protection mode (synchronous mirroring without automatic failover).
If you want to add a different witness, just set it up with a mirroring endpoint (ROLE=WITNESS), and then go to the principal and ALTER DATABASE yourdb SET WITNESS = 'yourwitnessIP/port'
Should work fine.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply