Multiple endpoint on one witness server(Mirroring), Is it possible? How?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » SQL Server 2008 High Availability » Multiple endpoint on one witness...

Add to briefcase

16 posts, Page 1 of 2

1 2 »»

Multiple endpoint on one witness server(Mirroring), Is it possible? How?

Expand / Collapse

Author

Message

Posted Wednesday, November 03, 2010 7:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 03, 2011 1:36 PM
Points: 4, Visits: 16

I have 3 database mirroring from different servers.

Can I use only 1 witness SQL server with multiple tcp endpoint? if yes,How?
Or What should I do to handle this situation? Separate witness sql server for each pair looks over kill for me.

I found it can use as witness for only 1 pair. If I try it on the second pair, it cut the witness out from first pair and left database as "Principle, Suspended"

Any help will be really appreciated.

Thank you in advance.

Post #1015210

Posted Wednesday, November 03, 2010 7:53 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 485, Visits: 1,568

we have 1 witness 'server', but each pair it monitors is a seperate instance.

so we have 6 database servers that are mirrored. (12 seperate servers)
we have 1 witness server with 6 instances running.

everything runs great.

Post #1015223

Posted Wednesday, November 03, 2010 8:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 03, 2011 1:36 PM
Points: 4, Visits: 16

Thank Geoff
Is it possible to do something like 1 SQL server instance, 6 TCP endpoints?

Post #1015251

Posted Wednesday, November 03, 2010 8:28 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 485, Visits: 1,568

no.
but you might be able to do something like;

instance pair 1 mirroring on port 5023
instance pair 2 mirroring on port 5024
instance pair 3 mirroring on port 5025

the witness instance has 1 endpoint all on port 5022

on each of the principal servers, run;
ALTER DATABASE <DATABASE_NAME>
SET WITNESS =
' TCP :// < system-address of the witness server > : 5022'
GO

however, the seperate instance on the witness will lead to a better solution imho....

Post #1015260

Posted Wednesday, November 03, 2010 10:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 03, 2011 1:36 PM
Points: 4, Visits: 16

Thank you so much.

For the second pair, I need to do mirroring in High Performance operating mode (change port as your reply) and add Witness as your reply on Principal later, everything comes out perfect.

Thank again.

Post #1015402

melissa.dougherty

Posted Tuesday, May 17, 2011 1:52 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:25 AM
Points: 12, Visits: 74

I am also trying to setup Mirroring with failover, the witness instance is on the same server as the mirror instance. My mirror has the default instance name, and my witness is named SQLWitness. How do I specify the following command, it will not allow me to name the instance.

ALTER DATABASE MainDB
SET WITNESS = 'TCP://MirrorDB\SQLWitness:5033';
GO

Post #1110570

Posted Wednesday, May 18, 2011 8:35 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,558, Visits: 1,396

Melissa, you have the slash going the wrong direction. Should be / instead of \.

SET WITNESS = 'TCP://MirrorDB\SQLWitness:5033';

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1111028

melissa.dougherty

Posted Wednesday, May 18, 2011 8:39 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:25 AM
Points: 12, Visits: 74

I'm almost certain I tried the forward slash.... but I will give it another try. Is there examples of this in the book you recommended?

Post #1111034

Posted Wednesday, May 18, 2011 8:55 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,558, Visits: 1,396

Yes, there are examples and much, much more in the book I wrote. :)

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1111064

melissa.dougherty

Posted Wednesday, May 18, 2011 9:12 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 11:25 AM
Points: 12, Visits: 74

When trying this command,

ALTER DATABASE SharePointDB
SET WITNESS = 'TCP://MirrorDB/SQLServerWitness:5033';
GO

I get the following error...

Msg 1449, Level 16, State 5, Line 1
ALTER DATABASE command failed due to an invalid server connection string.

Post #1111082

« Prev Topic | Next Topic »

Add to briefcase

16 posts, Page 1 of 2

1 2 »»

Permissions

Expand / Collapse