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.
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
and the mirror as
answered Feb 29 '12 at 11:09 AM
Kev Riley ♦♦