Creating a SQL Always On Availability Group Instance

After you install the SQL agent on all the physical nodes of an Always On cluster, create an availability group instance.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click Add instance, and then select Database server.

    The Select Database Type page appears.

  3. Select SQL availability group.

    The Add SQL availability group instance dialog box appears.

  4. From the Primary replica list, select the SQL Server client that is the primary replica of the availability group that you want to back up.

  5. From the SQL Server instance list, select an instance.

    If the SQL Server client has only one instance, then the instance is automatically selected.

  6. For Accounts, select one of the following options:

    • To use a local system user account for the backups, click Use local system account.

    • To use a different Windows user account, click Impersonate User, and then enter the credentials for the account.

      Note

      The account must be set up on the client and must have Local administrator privileges and be a member of the SQL sysadmin fixed server role for the instance.

  7. From the Plan list, select the backup plan to use for the instance.

Results

If you have multiple availability groups sharing the same primary replica, all the availability groups will be configured at once.

Loading...