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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 Reply to Topic
 Printer Friendly
Author Previous Topic 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
38200 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
38200 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
  Previous Topic Topic Next 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.11 seconds. Powered By: Snitz Forums 2000