| title | Select Databases Page (New Availability Group & Add Database Wizard) | ||
|---|---|---|---|
| description | Describes the "Select Databases" page for both the New Availability Group and Add Database Wizards found in SQL Server Management Studio GUI. | ||
| ms.custom | seo-lt-2019 | ||
| ms.date | 05/17/2016 | ||
| ms.prod | sql | ||
| ms.reviewer | |||
| ms.technology | high-availability | ||
| ms.topic | conceptual | ||
| f1_keywords |
|
||
| ms.assetid | 929c5e15-d087-438d-b1f2-aa97c5f8bff8 | ||
| author | MashaMSFT | ||
| ms.author | mathoma |
[!INCLUDE SQL Server] This help topic describes the options of the Specify Databases page. This topic applies to the [!INCLUDEssAoNewAgWiz] and [!INCLUDEssAoAddDbWiz] of [!INCLUDEssCurrent].
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.
Password
If the database contains a database master key, enter the password for the database master key.
Refresh
Click to refresh the grid. This is useful after you take action on a database to meet a prerequisite.
-
Use the New Availability Group Dialog Box (SQL Server Management Studio)
-
Use the Add Database to Availability Group Wizard (SQL Server Management Studio)
Overview of Always On Availability Groups (SQL Server)
Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)