SQL Mirroring + Multiple End Points on SQL Instance

Question

Post reply

SQL Mirroring + Multiple End Points on SQL Instance

cheshirefox

Hall of Fame

Points: 3464
More actions
December 9, 2010 at 10:27 am

#244074

I have a production SQL Instance running SQL 2008 SP1. I am mirroring several databases to another SQL 2008 SP1 Instance.
I have a new server running SQL 2008 R2.
I need to remirror each of the databases to the R2 SQL instance.
Ideally - I will create a second end point pointing to the new SQL 2008 R2 instance.
Then break each mirror one database at a time and recreate the mirror using the second endpoint - pointing the R2 SQL instance.
Has anyone created a second end point and mirrored databases to another SQL instance?
Any information you can provide is appreciated.
Matt

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234040 More actions · Answer 1

endpoints are created locally and used as the connection points between mirroring sessions!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"

cheshirefox Hall of Fame Points: 3464 More actions · Answer 2

So - have you configured multiple end points on the same SQL Instance and mirrored individual databases to different SQL instances?

IE - The principal server instance (A) has 2 user databases (1 and 2)... I have 2 additional SQL instance (B and C)...

Can I configure 2 endpoints on instance A then mirror database 1 to instance B and mirror database 2 to instance C?

Perry Whittle SSC Guru Points: 234040 More actions · Answer 3

cheshirefox (12/13/2010)
Can I configure 2 endpoints on instance A then mirror database 1 to instance B and mirror database 2 to instance C?

each sql server instance may have only 1 mirroring endpoint, all mirroring transport occurs through this endpoint. Multiple instances on a single server would each have their own endpoint with a unique port number. Do you understand?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Ok, I know it`s a 7 years old post, but I am stuck with some issue related to that post:

"Can I configure 2 different instances for a single database?! in other words can I mirror database 1 to instance B and then mirror database 1 to instance C?"

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Perry Whittle SSC Guru Points: 234040 More actions · Answer 6

What are you stuck with?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

@perry Whittle

I need to configure 2 different Mirroring instances for a single database?! in other words can I Mirror database 1 to instance B and then Mirror the same database to instance C?
Is this scenario possible?!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 8

No, not with mirroring. You could use replication or log-shipping, or (if you upgrade) AlwaysOn Availability Groups.

SQL Mirroring + Multiple End Points on SQL Instance

Cookies on SQLServerCentral