Select Databases Page (New Availability Group Wizard-Add Database Wizard)
This help topic describes the options of the Specify Databases page. This topic applies to the New Availability Group Wizard and Add Database to Availability Group Wizard of SQL Server 2014.
Select Databases Options
The User databases on this instance of SQL Server grid lists every local user database. The columns are as follows:
Name
Displays the name of a local user database.
Size
Displays the database size, if the size is available to the wizard.
Status
Displays a hyperlink whose text that indicates whether a given database meets the prerequisites for being added to an availability group. If the status is "Meets prerequisites" you can add the database to the availability group. If a database does not meet all of the prerequisites, the Status hyperlink provides a brief explanation of why the database is ineligible. For more information, click the hyperlink.
You can leave the wizard on the Select Database page while you take action on a database to meet a prerequisite. When you return to the Select Databases page, click Refresh to update the grid.
Refresh
Click to refresh the grid. This is useful after you take action on a database to meet a prerequisite.
Related Tasks
Use the New Availability Group Dialog Box (SQL Server Management Studio)
Use the Add Database to Availability Group Wizard (SQL Server Management Studio)
See Also
Overview of AlwaysOn Availability Groups (SQL Server)
Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)