View Availability Group Properties (SQL Server)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
This topic describes how to view the properties of an availability group for an AlwaysOn availability group by using SQL Server Management Studio or Transact-SQL in SQL Server 2016.
To view and change the properties an availability group
In Object Explorer, connect to the server instance that hosts the primary replica, and expand the server tree.
Expand the AlwaysOn High Availability node and the Availability Groups node.
Right-click the availability group whose properties you want to view, and select the Properties command.
In the Availability Group Properties dialog box, use the General and Backup Preferences 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 Permissions page to view the current logins, roles, and explicit permissions associated with the availability group. For more information, see Permissions or Securables Page.
To view the properties and state of an availability group
To query the properties and states of the availability groups for which the server instance hosts an availability replica, use the following views:
To view information about availability groups
To configure an existing availability group
To manually fail over an availability group