Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: New Availability Group Wizard-generated scripts skip the steps for joining a secondary database to an availability group in SQL Server 2012
Article ID: 2645920 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2012 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release.
Consider the following scenario:
Service pack information for SQL Server 2012To resolve this problem, obtain the latest service pack for SQL Server 2012. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2755533/ )How to obtain the latest service pack for SQL Server 2012
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To work around this issue, manually add the missing steps. Specifically, add the "ALTER DATABASE DatabaseName SET HADR AVAILBILLITY GROUP" command for each availability database and secondary replica that is defined in the availability group. For example, you add the following steps:
For more information about how to join a secondary database to an availability group, go to the following MSDN website:
How to join a secondary database to an availability groupFor more information about how to use the New Availability Group Wizard, go to the following MSDN website:
How to use the New Availability Group WizardFor more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates