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.
| Author |
Topic |
|
fishnowworknever
Starting Member
2 Posts |
 Posted - 2014-07-30 : 10:50:02
|
| 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.aspxMore 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? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-30 : 12:41:06
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
fishnowworknever
Starting Member
2 Posts |
Posted - 2014-07-30 : 13:24:39
|
| 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? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-30 : 14:09:26
|
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL 2012 AlwaysOn MultiSubnet - Importing Database