Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to configure DB Mirroring Endpoints Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 3:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
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?
Post #1423958
Posted Thursday, February 28, 2013 3:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,958, Visits: 12,839
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"
Post #1424976
Posted Thursday, February 28, 2013 6:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
Will two mirroring sessions on same instance use single endpoint or I require
two separate endpoint for two mirroring session on my box.
Post #1425015
Posted Thursday, February 28, 2013 6:26 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 22,492, Visits: 30,192
sej2008 (2/28/2013)
Will two mirroring sessions on same instance use single endpoint or I require
two 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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1425024
Posted Thursday, February 28, 2013 8:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 5,958, Visits: 12,839
sej2008 (2/28/2013)
Will two mirroring sessions on same instance use single endpoint or I require
two 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"
Post #1425078
Posted Thursday, February 28, 2013 10:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 1:30 AM
Points: 113, Visits: 207
Thanks
Post #1425358
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse