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

avatar image

MickyMd
11 2 3 4

(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

avatar image

Kev Riley ♦♦
63.8k 48 61 81

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:

x2016
x30
x2

asked: Feb 29, 2012 at 11:04 AM

Seen: 3227 times

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

Copyright 2016 Redgate Software. Privacy Policy