February 26, 2013 at 3:02 am
I have one System (box)on which I have two databases which are to be mirrored on another instance on the same system(computer/box) i.e DBprincipal1...............DBMIrror1
DBPrincipal2...............DBMirror2
Now can I use same endpoint for configuring two mirror sessions or will I require another mirror endpoint?
Another scenario where in if second instance is on the another box which will have mirror databases then how endpoints to be configured?and what about port number setting can I use same port number or has to be different for both the partners?
February 28, 2013 at 3:48 am
you need an endpoint on each instance in the mirror relationship, if they're on separate machines you can use the same port number.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 6:06 am
Will two mirroring sessions on same instance use single endpoint or I require
two separate endpoint for two mirroring session on my box.
February 28, 2013 at 6:26 am
sej2008 (2/28/2013)
Will two mirroring sessions on same instance use single endpoint or I requiretwo separate endpoint for two mirroring session on my box.
IIRC an instance can have only one mirror endpoint and that multiple sessions will share that endpoint.
You will need to check Books Online to be sure as it has been several years now since I dealt with mirroring.
February 28, 2013 at 8:51 am
sej2008 (2/28/2013)
Will two mirroring sessions on same instance use single endpoint or I requiretwo separate endpoint for two mirroring session on my box.
The endpoint is instance wide so both will use it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 10:58 pm
Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply