Multiple DB Mirroring and Single Witness server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Multiple DB Mirroring and Single Witness server

Author

Topic

rikleo2001
Posting Yak Master

185 Posts

Posted - 2009-01-26 : 11:12:11

Guys

Just want your confirmation and expert advice.

I have one Witness server with default instance and Multiple DB (Principal and Mirror servers)
I configured Witness server for one set of mirror on specific port on default instance, it worked fine.
Now when I tried to create a another endpoint on the same instance for another set of mirroring, it failed.

So my understanding is correct that there is only one Endpoint per instnace? also for mutiple mirrored server I have to create multiple instance on witness server?

Many Thanks

SKR

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-26 : 11:33:08

I use the same endpoint for each of my mirrors on the same instance. I have about 20-30 databases setup for database mirroring on the same instance (mirrored to another server obviously) and all use the same endpoint.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

rikleo2001
Posting Yak Master

185 Posts

Posted - 2009-01-27 : 03:52:02

Thanks for your reply.
Let me explain it in detail.

I have one Witness Server with only Default instance say WITNESS1

I have One pair of Mirror (Principle and Mirror) say Server1 and Server2 with lots with few databases

I configured Pricipal Server1 to use Witness1 server on port 12334
Works fine

Now I have another pair of mirror which is an instance on Server1 and Server 2 say Server1_Ins1 and Server2_ins1

Now when I go to configure Server1_ins1 witness server, and try to use Witness1 server as witness it by default accepts ports on 12334 and won't allow to change the ports..

I assume if I proceed with this proces it will override my exisiting settings of witness server for Server1 and Server2?

What I want to do is to without installing instances on Witness servers configure it to work with Multiple paired instances
Is this possible?

Thanks in advance.

SKR

rikleo2001
Posting Yak Master

185 Posts

Posted - 2009-01-27 : 03:59:31

This illustration may help to give you better understaning to what I want to achieve.

In below example Principal_? are multiple instances on server "server1" and Mirror_? on server "server2"
Where as Witness server is standalone server with default instance only.

Pricipal_1 <-Port 12345> Mirror_1 ->>> Witness Server Endpoint 12345
Pricipal_2 <-Port 12346> Mirror_2 ->>> Witness Server Endpoint 12346
Pricipal_3 <-Port 12347> Mirror_3 ->>> Witness Server Endpoint 12347

SKR

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-27 : 13:00:38

Why can't you use the same witness server endpoint for each?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

rikleo2001
Posting Yak Master

185 Posts

Posted - 2009-01-28 : 03:26:10

Ok, I have Paired Mirrored instance on Two servers , whih means I have to use unique port if I am using multiple instances on same server, here is what Microsoft says.
"If any of the SQL Server instances are on the same machine, each instance must have a distinct port and the port numbers must be unique"

Now how can I use Witness server one Endpoint to look after mirrored (principal and Mirror) on one port whereas they are on differant ports?

Any help?

SKR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources