Skip to content

Latest commit

 

History

History
63 lines (47 loc) · 3.98 KB

File metadata and controls

63 lines (47 loc) · 3.98 KB
title Specify Availability Group Options Page (New Availability Group Wizard/Add Database Wizard) | Microsoft Docs
ms.custom
ms.date 05/17/2016
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component availability-groups
ms.reviewer
ms.suite sql
ms.technology
dbe-high-availability
ms.tgt_pltfrm
ms.topic article
f1_keywords
sql13.swb.newagwizard.specifyagname.f1
sql13.swb.adddatabasewizard.specifyagname.f1
ms.assetid dcb6374d-becb-4c6c-b88c-5a8273f8aa38
caps.latest.revision 13
author MikeRayMSFT
ms.author mikeray
manager jhubbard
ms.workload Inactive

Specify Availability Group Options Page

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes the options of the Specify Availability Group Name page. This topic is used by both the [!INCLUDEssAoNewAgWiz] and [!INCLUDEssAoAddDbWiz] of [!INCLUDEssCurrent].

Specify Availability Group Options

Availability group name
Specify the name of the availability group. For a new availability group, specify a valid [!INCLUDEssNoVersion] identifier that is unique across all availability groups in the Windows Server failover cluster (WSFC). The maximum length for an availability group name is 128 characters.

Cluster type Next, specify the cluster type. The possible cluster types depend on the [!INCLUDEssNoVersion] version and operating system. Choose one from the following list:

  • Windows Server Failover Clustering

    Use when the availability group is hosted on instances of [!INCLUDEssNoVersion] that belong to a Windows Server failover cluster for high availability and disaster recovery. Applies to all supported versions of [!INCLUDEssNoVersion].

  • EXTERNAL

    Use when the availability group is hosted on an instance of [!INCLUDEssNoVersion] that is managed by an external cluster technology for high availability and disaster recovery, for example Pacemaker on Linux. Applies to [!INCLUDEsssqlv14] and later.

  • NONE

    Use when the availability group is hosted on an instance of [!INCLUDEssNoVersion] that is not managed by a cluster technology for read scale and load balancing. Applies to [!INCLUDEsssqlv14] and later.

Database level health detection Check this box to enable database level health detection (DB_FAILOVER) option for the availability group. The database health detection notices when a database is no longer in the online status, when something goes wrong and will trigger the automatic failover of the availability group. See SQL Server Always On Database Health Detection Failover Option.

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

Related Tasks

See Also

Overview of Always On Availability Groups (SQL Server)