azure-native.azurearcdata.getSqlServerAvailabilityGroup
Explore with Pulumi AI
Retrieves an Arc Sql Server availability group.
Uses Azure REST API version 2024-01-01.
Other available API versions: 2024-05-01-preview, 2025-03-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native azurearcdata [ApiVersion]
. See the version guide for details.
Using getSqlServerAvailabilityGroup
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getSqlServerAvailabilityGroup(args: GetSqlServerAvailabilityGroupArgs, opts?: InvokeOptions): Promise<GetSqlServerAvailabilityGroupResult>
function getSqlServerAvailabilityGroupOutput(args: GetSqlServerAvailabilityGroupOutputArgs, opts?: InvokeOptions): Output<GetSqlServerAvailabilityGroupResult>
def get_sql_server_availability_group(availability_group_name: Optional[str] = None,
resource_group_name: Optional[str] = None,
sql_server_instance_name: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetSqlServerAvailabilityGroupResult
def get_sql_server_availability_group_output(availability_group_name: Optional[pulumi.Input[str]] = None,
resource_group_name: Optional[pulumi.Input[str]] = None,
sql_server_instance_name: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetSqlServerAvailabilityGroupResult]
func LookupSqlServerAvailabilityGroup(ctx *Context, args *LookupSqlServerAvailabilityGroupArgs, opts ...InvokeOption) (*LookupSqlServerAvailabilityGroupResult, error)
func LookupSqlServerAvailabilityGroupOutput(ctx *Context, args *LookupSqlServerAvailabilityGroupOutputArgs, opts ...InvokeOption) LookupSqlServerAvailabilityGroupResultOutput
> Note: This function is named LookupSqlServerAvailabilityGroup
in the Go SDK.
public static class GetSqlServerAvailabilityGroup
{
public static Task<GetSqlServerAvailabilityGroupResult> InvokeAsync(GetSqlServerAvailabilityGroupArgs args, InvokeOptions? opts = null)
public static Output<GetSqlServerAvailabilityGroupResult> Invoke(GetSqlServerAvailabilityGroupInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetSqlServerAvailabilityGroupResult> getSqlServerAvailabilityGroup(GetSqlServerAvailabilityGroupArgs args, InvokeOptions options)
public static Output<GetSqlServerAvailabilityGroupResult> getSqlServerAvailabilityGroup(GetSqlServerAvailabilityGroupArgs args, InvokeOptions options)
fn::invoke:
function: azure-native:azurearcdata:getSqlServerAvailabilityGroup
arguments:
# arguments dictionary
The following arguments are supported:
- Availability
Group stringName - Name of SQL Availability Group
- Resource
Group stringName - The name of the Azure resource group
- Sql
Server stringInstance Name - Name of SQL Server Instance
- Availability
Group stringName - Name of SQL Availability Group
- Resource
Group stringName - The name of the Azure resource group
- Sql
Server stringInstance Name - Name of SQL Server Instance
- availability
Group StringName - Name of SQL Availability Group
- resource
Group StringName - The name of the Azure resource group
- sql
Server StringInstance Name - Name of SQL Server Instance
- availability
Group stringName - Name of SQL Availability Group
- resource
Group stringName - The name of the Azure resource group
- sql
Server stringInstance Name - Name of SQL Server Instance
- availability_
group_ strname - Name of SQL Availability Group
- resource_
group_ strname - The name of the Azure resource group
- sql_
server_ strinstance_ name - Name of SQL Server Instance
- availability
Group StringName - Name of SQL Availability Group
- resource
Group StringName - The name of the Azure resource group
- sql
Server StringInstance Name - Name of SQL Server Instance
getSqlServerAvailabilityGroup Result
The following output properties are available:
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- Location string
- The geo-location where the resource lives
- Name string
- The name of the resource
- Properties
Pulumi.
Azure Native. Azure Arc Data. Outputs. Sql Server Availability Group Resource Properties Response - Properties of Arc Sql Server availability group
- System
Data Pulumi.Azure Native. Azure Arc Data. Outputs. System Data Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Dictionary<string, string>
- Resource tags.
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- Location string
- The geo-location where the resource lives
- Name string
- The name of the resource
- Properties
Sql
Server Availability Group Resource Properties Response - Properties of Arc Sql Server availability group
- System
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- map[string]string
- Resource tags.
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location String
- The geo-location where the resource lives
- name String
- The name of the resource
- properties
Sql
Server Availability Group Resource Properties Response - Properties of Arc Sql Server availability group
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Map<String,String>
- Resource tags.
- azure
Api stringVersion - The Azure API version of the resource.
- id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location string
- The geo-location where the resource lives
- name string
- The name of the resource
- properties
Sql
Server Availability Group Resource Properties Response - Properties of Arc Sql Server availability group
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- {[key: string]: string}
- Resource tags.
- azure_
api_ strversion - The Azure API version of the resource.
- id str
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location str
- The geo-location where the resource lives
- name str
- The name of the resource
- properties
Sql
Server Availability Group Resource Properties Response - Properties of Arc Sql Server availability group
- system_
data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type str
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Mapping[str, str]
- Resource tags.
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location String
- The geo-location where the resource lives
- name String
- The name of the resource
- properties Property Map
- Properties of Arc Sql Server availability group
- system
Data Property Map - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Map<String>
- Resource tags.
Supporting Types
AvailabilityGroupConfigureResponse
- Availability
Mode stringDescription - The Availability Synchronization mode of the availability group replica.
- Failover
Mode stringDescription - The failover mode of the availability group replica.
- Primary
Role stringAllow Connections Description - Whether the availability allows all connections or only read-write connections.
- Replica
Create stringDate - Date that the replica was created.
- Replica
Modify stringDate - Date that the replica was modified.
- Secondary
Role stringAllow Connections Description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- Seeding
Mode stringDescription - Describes seeding mode.
- Backup
Priority int - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- Endpoint
Url string - Mirroring endpoint URL of availability group replica
- Read
Only stringRouting Url - Connectivity endpoint (URL) of the read only availability replica.
- Read
Write stringRouting Url - Connectivity endpoint (URL) of the read write availability replica.
- Session
Timeout int - The time-out period of availability group session replica, in seconds.
- Availability
Mode stringDescription - The Availability Synchronization mode of the availability group replica.
- Failover
Mode stringDescription - The failover mode of the availability group replica.
- Primary
Role stringAllow Connections Description - Whether the availability allows all connections or only read-write connections.
- Replica
Create stringDate - Date that the replica was created.
- Replica
Modify stringDate - Date that the replica was modified.
- Secondary
Role stringAllow Connections Description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- Seeding
Mode stringDescription - Describes seeding mode.
- Backup
Priority int - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- Endpoint
Url string - Mirroring endpoint URL of availability group replica
- Read
Only stringRouting Url - Connectivity endpoint (URL) of the read only availability replica.
- Read
Write stringRouting Url - Connectivity endpoint (URL) of the read write availability replica.
- Session
Timeout int - The time-out period of availability group session replica, in seconds.
- availability
Mode StringDescription - The Availability Synchronization mode of the availability group replica.
- failover
Mode StringDescription - The failover mode of the availability group replica.
- primary
Role StringAllow Connections Description - Whether the availability allows all connections or only read-write connections.
- replica
Create StringDate - Date that the replica was created.
- replica
Modify StringDate - Date that the replica was modified.
- secondary
Role StringAllow Connections Description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- seeding
Mode StringDescription - Describes seeding mode.
- backup
Priority Integer - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- endpoint
Url String - Mirroring endpoint URL of availability group replica
- read
Only StringRouting Url - Connectivity endpoint (URL) of the read only availability replica.
- read
Write StringRouting Url - Connectivity endpoint (URL) of the read write availability replica.
- session
Timeout Integer - The time-out period of availability group session replica, in seconds.
- availability
Mode stringDescription - The Availability Synchronization mode of the availability group replica.
- failover
Mode stringDescription - The failover mode of the availability group replica.
- primary
Role stringAllow Connections Description - Whether the availability allows all connections or only read-write connections.
- replica
Create stringDate - Date that the replica was created.
- replica
Modify stringDate - Date that the replica was modified.
- secondary
Role stringAllow Connections Description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- seeding
Mode stringDescription - Describes seeding mode.
- backup
Priority number - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- endpoint
Url string - Mirroring endpoint URL of availability group replica
- read
Only stringRouting Url - Connectivity endpoint (URL) of the read only availability replica.
- read
Write stringRouting Url - Connectivity endpoint (URL) of the read write availability replica.
- session
Timeout number - The time-out period of availability group session replica, in seconds.
- availability_
mode_ strdescription - The Availability Synchronization mode of the availability group replica.
- failover_
mode_ strdescription - The failover mode of the availability group replica.
- primary_
role_ strallow_ connections_ description - Whether the availability allows all connections or only read-write connections.
- replica_
create_ strdate - Date that the replica was created.
- replica_
modify_ strdate - Date that the replica was modified.
- secondary_
role_ strallow_ connections_ description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- seeding_
mode_ strdescription - Describes seeding mode.
- backup_
priority int - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- endpoint_
url str - Mirroring endpoint URL of availability group replica
- read_
only_ strrouting_ url - Connectivity endpoint (URL) of the read only availability replica.
- read_
write_ strrouting_ url - Connectivity endpoint (URL) of the read write availability replica.
- session_
timeout int - The time-out period of availability group session replica, in seconds.
- availability
Mode StringDescription - The Availability Synchronization mode of the availability group replica.
- failover
Mode StringDescription - The failover mode of the availability group replica.
- primary
Role StringAllow Connections Description - Whether the availability allows all connections or only read-write connections.
- replica
Create StringDate - Date that the replica was created.
- replica
Modify StringDate - Date that the replica was modified.
- secondary
Role StringAllow Connections Description - Whether an availability replica that is performing the secondary role (that is, a secondary replica) can accept connections from clients.
- seeding
Mode StringDescription - Describes seeding mode.
- backup
Priority Number - Represents the user-specified priority for performing backups on this replica relative to the other replicas in the same availability group.
- endpoint
Url String - Mirroring endpoint URL of availability group replica
- read
Only StringRouting Url - Connectivity endpoint (URL) of the read only availability replica.
- read
Write StringRouting Url - Connectivity endpoint (URL) of the read write availability replica.
- session
Timeout Number - The time-out period of availability group session replica, in seconds.
AvailabilityGroupInfoResponse
- Automated
Backup stringPreference Description - Preferred location for performing backups on the availability databases in this availability group.
- Cluster
Type stringDescription - SQL Server availability group cluster type description
- Primary
Recovery stringHealth Description - Indicates the recovery health of the primary replica.
- Primary
Replica string - Name of the server instance that is hosting the current primary replica.
- Replication
Partner stringType - Secondary
Recovery stringHealth Description - Indicates the recovery health of a secondary replica.
- Synchronization
Health stringDescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- Version int
- SQL Server availability group current version.
- Basic
Features bool - Specifies whether this is a basic availability group.
- Db
Failover bool - Specifies whether the availability group supports failover for database health conditions.
- Dtc
Support bool - Specifies whether DTC support has been enabled for this availability group.
- Failure
Condition intLevel - User-defined failure condition level under which an automatic failover must be triggered.
- Health
Check intTimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- Is
Contained bool - SQL Server availability group contained system databases.
- Is
Distributed bool - Specifies whether this is a distributed availability group.
- Required
Synchronized intSecondaries To Commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
- Automated
Backup stringPreference Description - Preferred location for performing backups on the availability databases in this availability group.
- Cluster
Type stringDescription - SQL Server availability group cluster type description
- Primary
Recovery stringHealth Description - Indicates the recovery health of the primary replica.
- Primary
Replica string - Name of the server instance that is hosting the current primary replica.
- Replication
Partner stringType - Secondary
Recovery stringHealth Description - Indicates the recovery health of a secondary replica.
- Synchronization
Health stringDescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- Version int
- SQL Server availability group current version.
- Basic
Features bool - Specifies whether this is a basic availability group.
- Db
Failover bool - Specifies whether the availability group supports failover for database health conditions.
- Dtc
Support bool - Specifies whether DTC support has been enabled for this availability group.
- Failure
Condition intLevel - User-defined failure condition level under which an automatic failover must be triggered.
- Health
Check intTimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- Is
Contained bool - SQL Server availability group contained system databases.
- Is
Distributed bool - Specifies whether this is a distributed availability group.
- Required
Synchronized intSecondaries To Commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
- automated
Backup StringPreference Description - Preferred location for performing backups on the availability databases in this availability group.
- cluster
Type StringDescription - SQL Server availability group cluster type description
- primary
Recovery StringHealth Description - Indicates the recovery health of the primary replica.
- primary
Replica String - Name of the server instance that is hosting the current primary replica.
- replication
Partner StringType - secondary
Recovery StringHealth Description - Indicates the recovery health of a secondary replica.
- synchronization
Health StringDescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- version Integer
- SQL Server availability group current version.
- basic
Features Boolean - Specifies whether this is a basic availability group.
- db
Failover Boolean - Specifies whether the availability group supports failover for database health conditions.
- dtc
Support Boolean - Specifies whether DTC support has been enabled for this availability group.
- failure
Condition IntegerLevel - User-defined failure condition level under which an automatic failover must be triggered.
- health
Check IntegerTimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- is
Contained Boolean - SQL Server availability group contained system databases.
- is
Distributed Boolean - Specifies whether this is a distributed availability group.
- required
Synchronized IntegerSecondaries To Commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
- automated
Backup stringPreference Description - Preferred location for performing backups on the availability databases in this availability group.
- cluster
Type stringDescription - SQL Server availability group cluster type description
- primary
Recovery stringHealth Description - Indicates the recovery health of the primary replica.
- primary
Replica string - Name of the server instance that is hosting the current primary replica.
- replication
Partner stringType - secondary
Recovery stringHealth Description - Indicates the recovery health of a secondary replica.
- synchronization
Health stringDescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- version number
- SQL Server availability group current version.
- basic
Features boolean - Specifies whether this is a basic availability group.
- db
Failover boolean - Specifies whether the availability group supports failover for database health conditions.
- dtc
Support boolean - Specifies whether DTC support has been enabled for this availability group.
- failure
Condition numberLevel - User-defined failure condition level under which an automatic failover must be triggered.
- health
Check numberTimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- is
Contained boolean - SQL Server availability group contained system databases.
- is
Distributed boolean - Specifies whether this is a distributed availability group.
- required
Synchronized numberSecondaries To Commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
- automated_
backup_ strpreference_ description - Preferred location for performing backups on the availability databases in this availability group.
- cluster_
type_ strdescription - SQL Server availability group cluster type description
- primary_
recovery_ strhealth_ description - Indicates the recovery health of the primary replica.
- primary_
replica str - Name of the server instance that is hosting the current primary replica.
- replication_
partner_ strtype - secondary_
recovery_ strhealth_ description - Indicates the recovery health of a secondary replica.
- synchronization_
health_ strdescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- version int
- SQL Server availability group current version.
- basic_
features bool - Specifies whether this is a basic availability group.
- db_
failover bool - Specifies whether the availability group supports failover for database health conditions.
- dtc_
support bool - Specifies whether DTC support has been enabled for this availability group.
- failure_
condition_ intlevel - User-defined failure condition level under which an automatic failover must be triggered.
- health_
check_ inttimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- is_
contained bool - SQL Server availability group contained system databases.
- is_
distributed bool - Specifies whether this is a distributed availability group.
- required_
synchronized_ intsecondaries_ to_ commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
- automated
Backup StringPreference Description - Preferred location for performing backups on the availability databases in this availability group.
- cluster
Type StringDescription - SQL Server availability group cluster type description
- primary
Recovery StringHealth Description - Indicates the recovery health of the primary replica.
- primary
Replica String - Name of the server instance that is hosting the current primary replica.
- replication
Partner StringType - secondary
Recovery StringHealth Description - Indicates the recovery health of a secondary replica.
- synchronization
Health StringDescription - Reflects a roll-up of the synchronization health of all availability replicas in the availability group.
- version Number
- SQL Server availability group current version.
- basic
Features Boolean - Specifies whether this is a basic availability group.
- db
Failover Boolean - Specifies whether the availability group supports failover for database health conditions.
- dtc
Support Boolean - Specifies whether DTC support has been enabled for this availability group.
- failure
Condition NumberLevel - User-defined failure condition level under which an automatic failover must be triggered.
- health
Check NumberTimeout - Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or not responding.
- is
Contained Boolean - SQL Server availability group contained system databases.
- is
Distributed Boolean - Specifies whether this is a distributed availability group.
- required
Synchronized NumberSecondaries To Commit - The number of secondary replicas that must be in a synchronized state for a commit to complete.
AvailabilityGroupStateResponse
- Availability
Group stringReplica Role - Current Always On availability groups role of the availability group replica.
- Connected
State stringDescription - Whether a secondary replica is currently connected to the primary replica.
- Last
Connect stringError Description - Text description of the last connection error of the availability group replica.
- Last
Connect stringError Timestamp - Date and time timestamp indicating when the last connect error occurred.
- Operational
State stringDescription - Current operational state of the availability group replica
- Recovery
Health stringDescription - Recovery health of the availability group replica.
- Synchronization
Health stringDescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
- Availability
Group stringReplica Role - Current Always On availability groups role of the availability group replica.
- Connected
State stringDescription - Whether a secondary replica is currently connected to the primary replica.
- Last
Connect stringError Description - Text description of the last connection error of the availability group replica.
- Last
Connect stringError Timestamp - Date and time timestamp indicating when the last connect error occurred.
- Operational
State stringDescription - Current operational state of the availability group replica
- Recovery
Health stringDescription - Recovery health of the availability group replica.
- Synchronization
Health stringDescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
- availability
Group StringReplica Role - Current Always On availability groups role of the availability group replica.
- connected
State StringDescription - Whether a secondary replica is currently connected to the primary replica.
- last
Connect StringError Description - Text description of the last connection error of the availability group replica.
- last
Connect StringError Timestamp - Date and time timestamp indicating when the last connect error occurred.
- operational
State StringDescription - Current operational state of the availability group replica
- recovery
Health StringDescription - Recovery health of the availability group replica.
- synchronization
Health StringDescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
- availability
Group stringReplica Role - Current Always On availability groups role of the availability group replica.
- connected
State stringDescription - Whether a secondary replica is currently connected to the primary replica.
- last
Connect stringError Description - Text description of the last connection error of the availability group replica.
- last
Connect stringError Timestamp - Date and time timestamp indicating when the last connect error occurred.
- operational
State stringDescription - Current operational state of the availability group replica
- recovery
Health stringDescription - Recovery health of the availability group replica.
- synchronization
Health stringDescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
- availability_
group_ strreplica_ role - Current Always On availability groups role of the availability group replica.
- connected_
state_ strdescription - Whether a secondary replica is currently connected to the primary replica.
- last_
connect_ strerror_ description - Text description of the last connection error of the availability group replica.
- last_
connect_ strerror_ timestamp - Date and time timestamp indicating when the last connect error occurred.
- operational_
state_ strdescription - Current operational state of the availability group replica
- recovery_
health_ strdescription - Recovery health of the availability group replica.
- synchronization_
health_ strdescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
- availability
Group StringReplica Role - Current Always On availability groups role of the availability group replica.
- connected
State StringDescription - Whether a secondary replica is currently connected to the primary replica.
- last
Connect StringError Description - Text description of the last connection error of the availability group replica.
- last
Connect StringError Timestamp - Date and time timestamp indicating when the last connect error occurred.
- operational
State StringDescription - Current operational state of the availability group replica
- recovery
Health StringDescription - Recovery health of the availability group replica.
- synchronization
Health StringDescription - Reflects a rollup of the database synchronization state (synchronization_state) of all joined availability databases (also known as replicas) and the availability mode of the replica (synchronous-commit or asynchronous-commit mode). The rollup will reflect the least healthy accumulated state the databases on the replica.
SqlAvailabilityGroupDatabaseReplicaResourcePropertiesResponse
- Database
State stringDescription - Description of the database state of the availability replica.
- Is
Commit boolParticipant - Whether this replica is transaction committer.
- Is
Local bool - Whether the availability database is local.
- Is
Primary boolReplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- Is
Suspended bool - Whether this data movement is suspended.
- Replica
Name string - the database replica name.
- Suspend
Reason stringDescription - Description of the database suspended state reason.
- Synchronization
Health stringDescription - Description of the health of database.
- Synchronization
State stringDescription - Description of the data-movement state.
- Database
Name string - the database name.
- Database
State stringDescription - Description of the database state of the availability replica.
- Is
Commit boolParticipant - Whether this replica is transaction committer.
- Is
Local bool - Whether the availability database is local.
- Is
Primary boolReplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- Is
Suspended bool - Whether this data movement is suspended.
- Replica
Name string - the database replica name.
- Suspend
Reason stringDescription - Description of the database suspended state reason.
- Synchronization
Health stringDescription - Description of the health of database.
- Synchronization
State stringDescription - Description of the data-movement state.
- Database
Name string - the database name.
- database
State StringDescription - Description of the database state of the availability replica.
- is
Commit BooleanParticipant - Whether this replica is transaction committer.
- is
Local Boolean - Whether the availability database is local.
- is
Primary BooleanReplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- is
Suspended Boolean - Whether this data movement is suspended.
- replica
Name String - the database replica name.
- suspend
Reason StringDescription - Description of the database suspended state reason.
- synchronization
Health StringDescription - Description of the health of database.
- synchronization
State StringDescription - Description of the data-movement state.
- database
Name String - the database name.
- database
State stringDescription - Description of the database state of the availability replica.
- is
Commit booleanParticipant - Whether this replica is transaction committer.
- is
Local boolean - Whether the availability database is local.
- is
Primary booleanReplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- is
Suspended boolean - Whether this data movement is suspended.
- replica
Name string - the database replica name.
- suspend
Reason stringDescription - Description of the database suspended state reason.
- synchronization
Health stringDescription - Description of the health of database.
- synchronization
State stringDescription - Description of the data-movement state.
- database
Name string - the database name.
- database_
state_ strdescription - Description of the database state of the availability replica.
- is_
commit_ boolparticipant - Whether this replica is transaction committer.
- is_
local bool - Whether the availability database is local.
- is_
primary_ boolreplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- is_
suspended bool - Whether this data movement is suspended.
- replica_
name str - the database replica name.
- suspend_
reason_ strdescription - Description of the database suspended state reason.
- synchronization_
health_ strdescription - Description of the health of database.
- synchronization_
state_ strdescription - Description of the data-movement state.
- database_
name str - the database name.
- database
State StringDescription - Description of the database state of the availability replica.
- is
Commit BooleanParticipant - Whether this replica is transaction committer.
- is
Local Boolean - Whether the availability database is local.
- is
Primary BooleanReplica - Returns 1 if the replica is primary, or 0 if it is a secondary replica.
- is
Suspended Boolean - Whether this data movement is suspended.
- replica
Name String - the database replica name.
- suspend
Reason StringDescription - Description of the database suspended state reason.
- synchronization
Health StringDescription - Description of the health of database.
- synchronization
State StringDescription - Description of the data-movement state.
- database
Name String - the database name.
SqlAvailabilityGroupReplicaResourcePropertiesResponse
- Replica
Id string - ID GUID of the availability group.
- Configure
Pulumi.
Azure Native. Azure Arc Data. Inputs. Availability Group Configure Response - null
- Replica
Name string - the replica name.
- State
Pulumi.
Azure Native. Azure Arc Data. Inputs. Availability Group State Response - null
- Replica
Id string - ID GUID of the availability group.
- Configure
Availability
Group Configure Response - null
- Replica
Name string - the replica name.
- State
Availability
Group State Response - null
- replica
Id String - ID GUID of the availability group.
- configure
Availability
Group Configure Response - null
- replica
Name String - the replica name.
- state
Availability
Group State Response - null
- replica
Id string - ID GUID of the availability group.
- configure
Availability
Group Configure Response - null
- replica
Name string - the replica name.
- state
Availability
Group State Response - null
- replica_
id str - ID GUID of the availability group.
- configure
Availability
Group Configure Response - null
- replica_
name str - the replica name.
- state
Availability
Group State Response - null
- replica
Id String - ID GUID of the availability group.
- configure Property Map
- null
- replica
Name String - the replica name.
- state Property Map
- null
SqlServerAvailabilityGroupResourcePropertiesResponse
- Availability
Group stringId - ID GUID of the availability group.
- Collection
Timestamp string - Timestamp for when the data was collected from the client machine.
- Instance
Name string - the SQL Server Instance name.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server availability group resource.
- Server
Name string - the SQL server name.
- Databases
Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Server Availability Group Resource Properties Response Databases - A list of Availability Group Database Replicas.
- Info
Pulumi.
Azure Native. Azure Arc Data. Inputs. Availability Group Info Response - Availability Group Info
- Replicas
Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Server Availability Group Resource Properties Response Replicas - A list of Availability Group Replicas.
- Availability
Group stringId - ID GUID of the availability group.
- Collection
Timestamp string - Timestamp for when the data was collected from the client machine.
- Instance
Name string - the SQL Server Instance name.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server availability group resource.
- Server
Name string - the SQL server name.
- Databases
Sql
Server Availability Group Resource Properties Response Databases - A list of Availability Group Database Replicas.
- Info
Availability
Group Info Response - Availability Group Info
- Replicas
Sql
Server Availability Group Resource Properties Response Replicas - A list of Availability Group Replicas.
- availability
Group StringId - ID GUID of the availability group.
- collection
Timestamp String - Timestamp for when the data was collected from the client machine.
- instance
Name String - the SQL Server Instance name.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server availability group resource.
- server
Name String - the SQL server name.
- databases
Sql
Server Availability Group Resource Properties Response Databases - A list of Availability Group Database Replicas.
- info
Availability
Group Info Response - Availability Group Info
- replicas
Sql
Server Availability Group Resource Properties Response Replicas - A list of Availability Group Replicas.
- availability
Group stringId - ID GUID of the availability group.
- collection
Timestamp string - Timestamp for when the data was collected from the client machine.
- instance
Name string - the SQL Server Instance name.
- provisioning
State string - The provisioning state of the Arc-enabled SQL Server availability group resource.
- server
Name string - the SQL server name.
- databases
Sql
Server Availability Group Resource Properties Response Databases - A list of Availability Group Database Replicas.
- info
Availability
Group Info Response - Availability Group Info
- replicas
Sql
Server Availability Group Resource Properties Response Replicas - A list of Availability Group Replicas.
- availability_
group_ strid - ID GUID of the availability group.
- collection_
timestamp str - Timestamp for when the data was collected from the client machine.
- instance_
name str - the SQL Server Instance name.
- provisioning_
state str - The provisioning state of the Arc-enabled SQL Server availability group resource.
- server_
name str - the SQL server name.
- databases
Sql
Server Availability Group Resource Properties Response Databases - A list of Availability Group Database Replicas.
- info
Availability
Group Info Response - Availability Group Info
- replicas
Sql
Server Availability Group Resource Properties Response Replicas - A list of Availability Group Replicas.
- availability
Group StringId - ID GUID of the availability group.
- collection
Timestamp String - Timestamp for when the data was collected from the client machine.
- instance
Name String - the SQL Server Instance name.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server availability group resource.
- server
Name String - the SQL server name.
- databases Property Map
- A list of Availability Group Database Replicas.
- info Property Map
- Availability Group Info
- replicas Property Map
- A list of Availability Group Replicas.
SqlServerAvailabilityGroupResourcePropertiesResponseDatabases
- Next
Link string - Link to retrieve next page of results.
- Value
List<Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Availability Group Database Replica Resource Properties Response> - Array of Availability Group Database Replicas.
- Next
Link string - Link to retrieve next page of results.
- Value
[]Sql
Availability Group Database Replica Resource Properties Response - Array of Availability Group Database Replicas.
- next
Link String - Link to retrieve next page of results.
- value
List<Sql
Availability Group Database Replica Resource Properties Response> - Array of Availability Group Database Replicas.
- next
Link string - Link to retrieve next page of results.
- value
Sql
Availability Group Database Replica Resource Properties Response[] - Array of Availability Group Database Replicas.
- next_
link str - Link to retrieve next page of results.
- value
Sequence[Sql
Availability Group Database Replica Resource Properties Response] - Array of Availability Group Database Replicas.
- next
Link String - Link to retrieve next page of results.
- value List<Property Map>
- Array of Availability Group Database Replicas.
SqlServerAvailabilityGroupResourcePropertiesResponseReplicas
- Next
Link string - Link to retrieve next page of results.
- Value
List<Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Availability Group Replica Resource Properties Response> - Array of Availability Group Replicas.
- Next
Link string - Link to retrieve next page of results.
- Value
[]Sql
Availability Group Replica Resource Properties Response - Array of Availability Group Replicas.
- next
Link String - Link to retrieve next page of results.
- value
List<Sql
Availability Group Replica Resource Properties Response> - Array of Availability Group Replicas.
- next
Link string - Link to retrieve next page of results.
- value
Sql
Availability Group Replica Resource Properties Response[] - Array of Availability Group Replicas.
- next_
link str - Link to retrieve next page of results.
- value
Sequence[Sql
Availability Group Replica Resource Properties Response] - Array of Availability Group Replicas.
- next
Link String - Link to retrieve next page of results.
- value List<Property Map>
- Array of Availability Group Replicas.
SystemDataResponse
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
- created
At string - The timestamp of resource creation (UTC).
- created
By string - The identity that created the resource.
- created
By stringType - The type of identity that created the resource.
- last
Modified stringAt - The timestamp of resource last modification (UTC)
- last
Modified stringBy - The identity that last modified the resource.
- last
Modified stringBy Type - The type of identity that last modified the resource.
- created_
at str - The timestamp of resource creation (UTC).
- created_
by str - The identity that created the resource.
- created_
by_ strtype - The type of identity that created the resource.
- last_
modified_ strat - The timestamp of resource last modification (UTC)
- last_
modified_ strby - The identity that last modified the resource.
- last_
modified_ strby_ type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0