|
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.
(comments are locked)
|
|
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 Many thanks Kev , so I was wrong in assuming they all need their own end point.
Feb 29 '12 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 '12 at 11:21 AM
Kev Riley ♦♦
As recommended in BOL, you should use only one endpoint
Feb 29 '12 at 11:30 AM
robbin
many thanks all that is just what I needed from BOL.
Feb 29 '12 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 '12 at 12:02 PM
robbin
(comments are locked)
|
