DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops
high availability
#high-availability#view-availability-group-properties

View availability group properties

This topic describes how to view the properties of an availability group for an Always On

availability group by using SQL Server Management Studio or Transact-SQL in SQL Server.

  1. In Object Explorer, connect to the server instance that hosts the primary replica, and

expand the server tree.

  1. Expand the

node and the

node.

  1. Right-click the availability group whose properties you want to view, and select the

command.

  1. In the

dialog box, use the

and

pages to view and, in some cases, change properties of the selected availability group. For

more information, see

Availability Group Properties: New Availability Group (General

Page)

and

Availability Group Properties: New Availability Group (Backup Preferences

Page).

Use the

page to view the current logins, roles, and explicit permissions

associated with the availability group. For more information, see

Permissions or

Securables Page.

To query the properties and states of the availability groups for which the server instance hosts

an availability replica, use the following views:

sys.availability_groups

Returns a row for each availability group for which the local instance of SQL Server hosts an

availability replica. Each row contains a cached copy of the availability group metadata.