SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 SQL 2012 AlwaysOn MultiSubnet - Importing Database
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

fishnowworknever
Starting Member

USA
2 Posts

Posted - 07/30/2014 :  10:50:02  Show Profile  Reply with Quote
We have imported multiple databases into our alwayson AG. I'm wondering if we need to run any additional update statements against those DB's.

The reason I ask is because we have a CRM environment that when we imported those CRM DB's into the AlwaysOn environment we followed this:

http://msdn.microsoft.com/en-us/library/jj822357.aspx

More specifically, this:

Update Organization set ConnectionString = 'Provider=SQLOLEDB;Data Source=AG_Listener_Name;Initial Catalog=OrganizationName_MSCRM;Integrated Security=SSPI;multisubnetfailover=true' where DatabaseName = 'OrganizationName_MSCRM'


These databases in question are not tied to CRM so the above update statement wouldn't make sense...however the "multisubnetfailover=true" is valid, do I need to update these databases somehow to incorporate this connection string?

Edited by - fishnowworknever on 07/30/2014 10:52:17

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 07/30/2014 :  12:41:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
Nothing needs to be done to the databases for the connection string.

multisubnetfailover=true is only needed if the Availability Group has replicas in different subnets, which is typically the case when a DR server is part of the AG.

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

fishnowworknever
Starting Member

USA
2 Posts

Posted - 07/30/2014 :  13:24:39  Show Profile  Reply with Quote
Tara,

Thanks for the reply. In our case we do have a replica in one subnet and our DR replica in another subnet.

The link I posted specifically states it's for "CRM" but would that multisubnetfailover=true apply to our imported, non-CRM databases?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 07/30/2014 :  14:09:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
The multisubnetfailover option applies to ALL databases in an Availability Group that has replicas in different subnets. CRM or non-CRM does not matter.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000