Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Bicep resource definition
The sqlServerInstances resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.AzureArcData/sqlServerInstances@2024-05-01-preview' = {
location: 'string'
name: 'string'
properties: {
backupPolicy: {
differentialBackupHours: int
fullBackupDays: int
retentionPeriodDays: int
transactionLogBackupMinutes: int
}
clientConnection: {
enabled: bool
}
cores: 'string'
databaseMirroringEndpoint: {}
edition: 'string'
failoverCluster: {}
hostType: 'string'
instanceName: 'string'
migration: {
assessment: {
enabled: bool
}
}
monitoring: {
enabled: bool
}
serviceType: 'string'
upgradeLockedUntil: 'string'
version: 'string'
}
tags: {
{customized property}: 'string'
}
}
Property Values
Microsoft.AzureArcData/sqlServerInstances
| Name | Description | Value |
|---|---|---|
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlServerInstanceProperties |
| tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
BackupPolicy
| Name | Description | Value |
|---|---|---|
| differentialBackupHours | The differential backup interval in hours. | int |
| fullBackupDays | The value indicating days between full backups. | int Constraints: Min value = 0 Max value = 7 |
| retentionPeriodDays | The retention period for all the databases in this managed instance. | int Constraints: Min value = 0 Max value = 35 |
| transactionLogBackupMinutes | The value indicating minutes between transaction log backups. | int Constraints: Min value = 0 Max value = 60 |
ClientConnection
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if client connection is enabled for this SQL Server instance. | bool |
DBMEndpoint
| Name | Description | Value |
|---|
FailoverCluster
| Name | Description | Value |
|---|
Migration
| Name | Description | Value |
|---|---|---|
| assessment | Migration assessments related configuration. | MigrationAssessment |
MigrationAssessment
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if migration assessment is enabled for this SQL Server instance. | bool |
Monitoring
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if monitoring is enabled for this SQL Server instance. | bool |
SqlServerInstanceProperties
| Name | Description | Value |
|---|---|---|
| backupPolicy | The backup profile for the SQL server. | BackupPolicy |
| clientConnection | Client connection related configuration. | ClientConnection |
| cores | The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance. | string |
| databaseMirroringEndpoint | Database mirroring endpoint related properties. | DBMEndpoint |
| edition | SQL Server edition. | 'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard' 'Web' |
| failoverCluster | Failover Cluster Instance properties. | FailoverCluster |
| hostType | Type of host for Azure Arc SQL Server | 'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine' |
| instanceName | SQL Server instance name. | string |
| migration | Migration related configuration. | Migration |
| monitoring | The monitoring configuration. | Monitoring |
| serviceType | Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host. | 'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS' |
| upgradeLockedUntil | Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty. | string |
| version | SQL Server version. | 'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'Unknown' |
TrackedResourceTags
| Name | Description | Value |
|---|
ARM template resource definition
The sqlServerInstances resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following JSON to your template.
{
"type": "Microsoft.AzureArcData/sqlServerInstances",
"apiVersion": "2024-05-01-preview",
"name": "string",
"location": "string",
"properties": {
"backupPolicy": {
"differentialBackupHours": "int",
"fullBackupDays": "int",
"retentionPeriodDays": "int",
"transactionLogBackupMinutes": "int"
},
"clientConnection": {
"enabled": "bool"
},
"cores": "string",
"databaseMirroringEndpoint": {
},
"edition": "string",
"failoverCluster": {
},
"hostType": "string",
"instanceName": "string",
"migration": {
"assessment": {
"enabled": "bool"
}
},
"monitoring": {
"enabled": "bool"
},
"serviceType": "string",
"upgradeLockedUntil": "string",
"version": "string"
},
"tags": {
"{customized property}": "string"
}
}
Property Values
Microsoft.AzureArcData/sqlServerInstances
| Name | Description | Value |
|---|---|---|
| apiVersion | The api version | '2024-05-01-preview' |
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlServerInstanceProperties |
| tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
| type | The resource type | 'Microsoft.AzureArcData/sqlServerInstances' |
BackupPolicy
| Name | Description | Value |
|---|---|---|
| differentialBackupHours | The differential backup interval in hours. | int |
| fullBackupDays | The value indicating days between full backups. | int Constraints: Min value = 0 Max value = 7 |
| retentionPeriodDays | The retention period for all the databases in this managed instance. | int Constraints: Min value = 0 Max value = 35 |
| transactionLogBackupMinutes | The value indicating minutes between transaction log backups. | int Constraints: Min value = 0 Max value = 60 |
ClientConnection
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if client connection is enabled for this SQL Server instance. | bool |
DBMEndpoint
| Name | Description | Value |
|---|
FailoverCluster
| Name | Description | Value |
|---|
Migration
| Name | Description | Value |
|---|---|---|
| assessment | Migration assessments related configuration. | MigrationAssessment |
MigrationAssessment
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if migration assessment is enabled for this SQL Server instance. | bool |
Monitoring
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if monitoring is enabled for this SQL Server instance. | bool |
SqlServerInstanceProperties
| Name | Description | Value |
|---|---|---|
| backupPolicy | The backup profile for the SQL server. | BackupPolicy |
| clientConnection | Client connection related configuration. | ClientConnection |
| cores | The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance. | string |
| databaseMirroringEndpoint | Database mirroring endpoint related properties. | DBMEndpoint |
| edition | SQL Server edition. | 'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard' 'Web' |
| failoverCluster | Failover Cluster Instance properties. | FailoverCluster |
| hostType | Type of host for Azure Arc SQL Server | 'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine' |
| instanceName | SQL Server instance name. | string |
| migration | Migration related configuration. | Migration |
| monitoring | The monitoring configuration. | Monitoring |
| serviceType | Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host. | 'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS' |
| upgradeLockedUntil | Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty. | string |
| version | SQL Server version. | 'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'Unknown' |
TrackedResourceTags
| Name | Description | Value |
|---|
Usage Examples
Terraform (AzAPI provider) resource definition
The sqlServerInstances resource type can be deployed with operations that target:
- Resource groups
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following Terraform to your template.
resource "azapi_resource" "symbolicname" {
type = "Microsoft.AzureArcData/sqlServerInstances@2024-05-01-preview"
name = "string"
parent_id = "string"
location = "string"
tags = {
{customized property} = "string"
}
body = {
properties = {
backupPolicy = {
differentialBackupHours = int
fullBackupDays = int
retentionPeriodDays = int
transactionLogBackupMinutes = int
}
clientConnection = {
enabled = bool
}
cores = "string"
databaseMirroringEndpoint = {
}
edition = "string"
failoverCluster = {
}
hostType = "string"
instanceName = "string"
migration = {
assessment = {
enabled = bool
}
}
monitoring = {
enabled = bool
}
serviceType = "string"
upgradeLockedUntil = "string"
version = "string"
}
}
}
Property Values
Microsoft.AzureArcData/sqlServerInstances
| Name | Description | Value |
|---|---|---|
| location | The geo-location where the resource lives | string (required) |
| name | The resource name | string (required) |
| properties | null | SqlServerInstanceProperties |
| tags | Resource tags | Dictionary of tag names and values. |
| type | The resource type | "Microsoft.AzureArcData/sqlServerInstances@2024-05-01-preview" |
BackupPolicy
| Name | Description | Value |
|---|---|---|
| differentialBackupHours | The differential backup interval in hours. | int |
| fullBackupDays | The value indicating days between full backups. | int Constraints: Min value = 0 Max value = 7 |
| retentionPeriodDays | The retention period for all the databases in this managed instance. | int Constraints: Min value = 0 Max value = 35 |
| transactionLogBackupMinutes | The value indicating minutes between transaction log backups. | int Constraints: Min value = 0 Max value = 60 |
ClientConnection
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if client connection is enabled for this SQL Server instance. | bool |
DBMEndpoint
| Name | Description | Value |
|---|
FailoverCluster
| Name | Description | Value |
|---|
Migration
| Name | Description | Value |
|---|---|---|
| assessment | Migration assessments related configuration. | MigrationAssessment |
MigrationAssessment
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if migration assessment is enabled for this SQL Server instance. | bool |
Monitoring
| Name | Description | Value |
|---|---|---|
| enabled | Indicates if monitoring is enabled for this SQL Server instance. | bool |
SqlServerInstanceProperties
| Name | Description | Value |
|---|---|---|
| backupPolicy | The backup profile for the SQL server. | BackupPolicy |
| clientConnection | Client connection related configuration. | ClientConnection |
| cores | The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance. | string |
| databaseMirroringEndpoint | Database mirroring endpoint related properties. | DBMEndpoint |
| edition | SQL Server edition. | 'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard' 'Web' |
| failoverCluster | Failover Cluster Instance properties. | FailoverCluster |
| hostType | Type of host for Azure Arc SQL Server | 'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine' |
| instanceName | SQL Server instance name. | string |
| migration | Migration related configuration. | Migration |
| monitoring | The monitoring configuration. | Monitoring |
| serviceType | Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host. | 'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS' |
| upgradeLockedUntil | Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty. | string |
| version | SQL Server version. | 'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'Unknown' |
TrackedResourceTags
| Name | Description | Value |
|---|