Select Databases Page (New Availability Group Wizard and Add Database Wizard)

Applies to: SQL Server

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.

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.

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.

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 Always On Availability Groups (SQL Server)
Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)