December 9, 2010 at 10:27 am
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
December 12, 2010 at 1:47 am
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" 😉
December 13, 2010 at 7:50 am
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?
December 13, 2010 at 1:17 pm
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" 😉
March 19, 2017 at 7:04 am
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
March 19, 2017 at 7:04 am
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
March 20, 2017 at 2:09 am
What are you stuck with?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2017 at 2:38 am
@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
March 21, 2017 at 4:09 am
No, not with mirroring. You could use replication or log-shipping, or (if you upgrade) AlwaysOn Availability Groups.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply