Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Two instances with same name

Author  Topic 

Aivlis
Starting Member

6 Posts

Posted - 2014-06-18 : 14:42:12
Hi there.

I need help! My issue is that: here have to datamirror servers, and when the first fail, mirror needs to assume with the same name.

I'll try explain: SD01 - Primary, SD02 - mirror. If SD01 fails, SD02 assumes called SD01. By the way, the instances are in same domain, but not in same computer.

Any feedback is grateful.

Be brave.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-18 : 15:03:29
You can use a DNS alias that the connection strings would use, but I would advise using Availability Groups instead where you would use an AG Listener.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Aivlis
Starting Member

6 Posts

Posted - 2014-06-18 : 15:08:21
I'll try.
Thanks a lot.

Be brave.
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-06-18 : 19:28:34
You could also consider changing the connection string to define a "Failover Partner". This defines a second server to use if the primry becomes unavailable. This link would have specifics depending on how you connect to your server: http://www.connectionstrings.com/



Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy
Go to Top of Page

Aivlis
Starting Member

6 Posts

Posted - 2014-06-20 : 07:56:11
Are you saying I can configure the "same" connection on two instances? I'm already using failover datamirror.

Be brave.
Go to Top of Page
   

- Advertisement -