x

SQL 2005 mirroring endpoints

Hi everyone. hope someone can help me out here.

If I want to mirror 3 x different databases on the same instance , do they all need their own TCP endpoint , or do I use just 1 end point for them all ? guessing they all need their own endpoint in the same instance ?

thanks in advance.
more ▼

asked Feb 29, 2012 at 11:04 AM in Default

MickyMd gravatar image

MickyMd
11 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You specify the endpoints for each database, but they can all be the same.

For example I have one client who has a Primary server DBSERVER01 and a mirror server DBSERVER02. For each of the databases configured in database mirroring I have configured the Principal end-point as

TCP://DBSERVER01.domain.com:5022

and the mirror as

TCP://DBSERVER02.domain.com:5022

more ▼

answered Feb 29, 2012 at 11:09 AM

Kev Riley gravatar image

Kev Riley ♦♦
54.3k 47 49 76

Many thanks Kev , so I was wrong in assuming they all need their own end point.
Feb 29, 2012 at 11:16 AM MickyMd
Well you could do it that way, having separate endpoints per database, but not sure what you would gain.
Feb 29, 2012 at 11:21 AM Kev Riley ♦♦

As recommended in BOL, you should use only one endpoint

If a database mirroring endpoint exists and is already in use, we recommend that you use that endpoint for every session on the server
> instance
Feb 29, 2012 at 11:30 AM robbin
many thanks all that is just what I needed from BOL.
Feb 29, 2012 at 11:33 AM MickyMd

@MickyMd Can you please change the title of the question to a more precise subject? Thanks

@Kev Riley On many such Q&A sites, the questions can be edited by the moderators/users. Is this option available here?
Feb 29, 2012 at 12:02 PM robbin
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x58
x1

asked: Feb 29, 2012 at 11:04 AM

Seen: 1690 times

Last Updated: Feb 29, 2012 at 12:06 PM