Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)

Question

Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)

Harshana-455711

Right there with Babe

Points: 797
More actions
February 28, 2020 at 8:43 pm
Go to Answer
#3729723
Hi
I have SQL Server FCI running in my DC site following are cluster details
Windows Cluster Name - DCWINCLS - 192.168.10.49
MSDTC - DCMSDTC - 192.168.10.50
SQL Role - DCSQL - 192.168.10.51
Now I want to create same SQL Server FCI in DR site as well so my concern is can we use same SQL Role name (DCSQL) and MSDTC name (DCMSDTC) in my new DR site.
Appreciate if someone can advice on this.
Thanks
- This topic was modified 4 years, 9 months ago by Harshana-455711.
Jeffrey Williams

SSC Guru

Points: 90303
More actions
March 1, 2020 at 5:50 pm
Answer
#3729973

Depends on how you are setting up your DR system. If you are going to use some method outside SQL Server to replicate the data to the DR site then it might be possible...
But - if you are using SQL Server functionality - as in building out a distributed availability group then you would not be able to do that...
Why do you need to worry about the name being the same, what is the goal to doing so? If you have to failover to the DR site then you can easily update DNS if needed to redirect to the appropriate addresses.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

You cannot use the same name - as that is going to be registered in DNS and you cannot have the same name with different IP addresses on the same network.

If your other DC is on a different domain then you could use the same name, but you also have the issue of how to set that up.

I would recommend setting up a cluster across both DC's and building out a distributed AG to support your DR.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-distributed-availability-groups?view=sql-server-ver15

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Harshana-455711 Right there with Babe Points: 797 More actions · Answer 2

Hi Jeffrey

Thanks you very much for your advice

We are planned to deploy new separate domain in our DR site, base on your advice I think we can deploy with same name if it is a separate domain, am I correct ?

Thanks

Harshana-455711 Right there with Babe Points: 797 More actions · Answer 3

Hi Jeffrey

Thanks a lot for your advice. We plan to deploy our DR site with separate domain + different name for the SQL cluster. We understand if we go with same name we have to face issues.

Thanks a lot for your valuable information.

Thanks

This reply was modified 4 years, 9 months ago by Harshana-455711.