question

MickyMd avatar image
MickyMd asked

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.
sql-server-2005database-mirroringdatabase-mirroring-endpoint
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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
6 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

robbin avatar image robbin commented ·
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
3 Likes 3 ·
MickyMd avatar image MickyMd commented ·
Many thanks Kev , so I was wrong in assuming they all need their own end point.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Well you could do it that way, having separate endpoints per database, but not sure what you would gain.
0 Likes 0 ·
MickyMd avatar image MickyMd commented ·
many thanks all that is just what I needed from BOL.
0 Likes 0 ·
robbin avatar image robbin commented ·
@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?
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.