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 2012.

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.

[Top]

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)

[Top]

See Also

Concepts

Overview of AlwaysOn Availability Groups (SQL Server)

Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)