azure-native.azurearcdata.SqlServerInstance
Explore with Pulumi AI
A SqlServerInstance.
Uses Azure REST API version 2024-01-01. In version 2.x of the Azure Native provider, it used API version 2023-01-15-preview.
Other available API versions: 2023-01-15-preview, 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.
Create SqlServerInstance Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SqlServerInstance(name: string, args: SqlServerInstanceArgs, opts?: CustomResourceOptions);
@overload
def SqlServerInstance(resource_name: str,
args: SqlServerInstanceArgs,
opts: Optional[ResourceOptions] = None)
@overload
def SqlServerInstance(resource_name: str,
opts: Optional[ResourceOptions] = None,
resource_group_name: Optional[str] = None,
location: Optional[str] = None,
properties: Optional[SqlServerInstancePropertiesArgs] = None,
sql_server_instance_name: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None)
func NewSqlServerInstance(ctx *Context, name string, args SqlServerInstanceArgs, opts ...ResourceOption) (*SqlServerInstance, error)
public SqlServerInstance(string name, SqlServerInstanceArgs args, CustomResourceOptions? opts = null)
public SqlServerInstance(String name, SqlServerInstanceArgs args)
public SqlServerInstance(String name, SqlServerInstanceArgs args, CustomResourceOptions options)
type: azure-native:azurearcdata:SqlServerInstance
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name
This property is required. string - The unique name of the resource.
- args
This property is required. SqlServerInstanceArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name
This property is required. str - The unique name of the resource.
- args
This property is required. SqlServerInstanceArgs - The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. SqlServerInstanceArgs - The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. SqlServerInstanceArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name
This property is required. String - The unique name of the resource.
- args
This property is required. SqlServerInstanceArgs - The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var sqlServerInstanceResource = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstanceResource", new()
{
ResourceGroupName = "string",
Location = "string",
Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
{
BackupPolicy = new AzureNative.AzureArcData.Inputs.BackupPolicyArgs
{
DifferentialBackupHours = 0,
FullBackupDays = 0,
RetentionPeriodDays = 0,
TransactionLogBackupMinutes = 0,
},
Cores = "string",
Edition = "string",
HostType = "string",
InstanceName = "string",
Monitoring = new AzureNative.AzureArcData.Inputs.MonitoringArgs
{
Enabled = false,
},
UpgradeLockedUntil = "string",
Version = "string",
},
SqlServerInstanceName = "string",
Tags =
{
{ "string", "string" },
},
});
example, err := azurearcdata.NewSqlServerInstance(ctx, "sqlServerInstanceResource", &azurearcdata.SqlServerInstanceArgs{
ResourceGroupName: pulumi.String("string"),
Location: pulumi.String("string"),
Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
BackupPolicy: &azurearcdata.BackupPolicyArgs{
DifferentialBackupHours: pulumi.Int(0),
FullBackupDays: pulumi.Int(0),
RetentionPeriodDays: pulumi.Int(0),
TransactionLogBackupMinutes: pulumi.Int(0),
},
Cores: pulumi.String("string"),
Edition: pulumi.String("string"),
HostType: pulumi.String("string"),
InstanceName: pulumi.String("string"),
Monitoring: &azurearcdata.MonitoringArgs{
Enabled: pulumi.Bool(false),
},
UpgradeLockedUntil: pulumi.String("string"),
Version: pulumi.String("string"),
},
SqlServerInstanceName: pulumi.String("string"),
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
})
var sqlServerInstanceResource = new SqlServerInstance("sqlServerInstanceResource", SqlServerInstanceArgs.builder()
.resourceGroupName("string")
.location("string")
.properties(SqlServerInstancePropertiesArgs.builder()
.backupPolicy(BackupPolicyArgs.builder()
.differentialBackupHours(0)
.fullBackupDays(0)
.retentionPeriodDays(0)
.transactionLogBackupMinutes(0)
.build())
.cores("string")
.edition("string")
.hostType("string")
.instanceName("string")
.monitoring(MonitoringArgs.builder()
.enabled(false)
.build())
.upgradeLockedUntil("string")
.version("string")
.build())
.sqlServerInstanceName("string")
.tags(Map.of("string", "string"))
.build());
sql_server_instance_resource = azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource",
resource_group_name="string",
location="string",
properties={
"backup_policy": {
"differential_backup_hours": 0,
"full_backup_days": 0,
"retention_period_days": 0,
"transaction_log_backup_minutes": 0,
},
"cores": "string",
"edition": "string",
"host_type": "string",
"instance_name": "string",
"monitoring": {
"enabled": False,
},
"upgrade_locked_until": "string",
"version": "string",
},
sql_server_instance_name="string",
tags={
"string": "string",
})
const sqlServerInstanceResource = new azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource", {
resourceGroupName: "string",
location: "string",
properties: {
backupPolicy: {
differentialBackupHours: 0,
fullBackupDays: 0,
retentionPeriodDays: 0,
transactionLogBackupMinutes: 0,
},
cores: "string",
edition: "string",
hostType: "string",
instanceName: "string",
monitoring: {
enabled: false,
},
upgradeLockedUntil: "string",
version: "string",
},
sqlServerInstanceName: "string",
tags: {
string: "string",
},
});
type: azure-native:azurearcdata:SqlServerInstance
properties:
location: string
properties:
backupPolicy:
differentialBackupHours: 0
fullBackupDays: 0
retentionPeriodDays: 0
transactionLogBackupMinutes: 0
cores: string
edition: string
hostType: string
instanceName: string
monitoring:
enabled: false
upgradeLockedUntil: string
version: string
resourceGroupName: string
sqlServerInstanceName: string
tags:
string: string
SqlServerInstance Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The SqlServerInstance resource accepts the following input properties:
- Resource
Group Name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- Location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- Properties
Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Server Instance Properties - null
- Sql
Server Instance Name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- Dictionary<string, string>
- Resource tags.
- Resource
Group Name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- Location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- Properties
Sql
Server Instance Properties Args - null
- Sql
Server Instance Name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- map[string]string
- Resource tags.
- resource
Group Name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties - null
- sql
Server Instance Name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- Map<String,String>
- Resource tags.
- resource
Group Name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties - null
- sql
Server Instance Name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- {[key: string]: string}
- Resource tags.
- resource_
group_ name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties Args - null
- sql_
server_ instance_ name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- Mapping[str, str]
- Resource tags.
- resource
Group Name This property is required. Changes to this property will trigger replacement.
- The name of the Azure resource group
- location
Changes to this property will trigger replacement.
- The geo-location where the resource lives
- properties Property Map
- null
- sql
Server Instance Name Changes to this property will trigger replacement.
- Name of SQL Server Instance
- Map<String>
- Resource tags.
Outputs
All input properties are implicitly available as output properties. Additionally, the SqlServerInstance resource produces the following output properties:
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- The name of the resource
- 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"
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- The name of the resource
- 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"
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- The name of the resource
- 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"
- azure
Api stringVersion - The Azure API version of the resource.
- id string
- The provider-assigned unique ID for this managed resource.
- name string
- The name of the resource
- 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"
- azure_
api_ strversion - The Azure API version of the resource.
- id str
- The provider-assigned unique ID for this managed resource.
- name str
- The name of the resource
- 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"
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- The name of the resource
- 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"
Supporting Types
BackupPolicy, BackupPolicyArgs
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup IntegerHours - The differential backup interval in hours.
- full
Backup IntegerDays - The value indicating days between full backups.
- retention
Period IntegerDays - The retention period for all the databases in this managed instance.
- transaction
Log IntegerBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup numberHours - The differential backup interval in hours.
- full
Backup numberDays - The value indicating days between full backups.
- retention
Period numberDays - The retention period for all the databases in this managed instance.
- transaction
Log numberBackup Minutes - The value indicating minutes between transaction log backups.
- differential_
backup_ inthours - The differential backup interval in hours.
- full_
backup_ intdays - The value indicating days between full backups.
- retention_
period_ intdays - The retention period for all the databases in this managed instance.
- transaction_
log_ intbackup_ minutes - The value indicating minutes between transaction log backups.
- differential
Backup NumberHours - The differential backup interval in hours.
- full
Backup NumberDays - The value indicating days between full backups.
- retention
Period NumberDays - The retention period for all the databases in this managed instance.
- transaction
Log NumberBackup Minutes - The value indicating minutes between transaction log backups.
BackupPolicyResponse, BackupPolicyResponseArgs
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup IntegerHours - The differential backup interval in hours.
- full
Backup IntegerDays - The value indicating days between full backups.
- retention
Period IntegerDays - The retention period for all the databases in this managed instance.
- transaction
Log IntegerBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup numberHours - The differential backup interval in hours.
- full
Backup numberDays - The value indicating days between full backups.
- retention
Period numberDays - The retention period for all the databases in this managed instance.
- transaction
Log numberBackup Minutes - The value indicating minutes between transaction log backups.
- differential_
backup_ inthours - The differential backup interval in hours.
- full_
backup_ intdays - The value indicating days between full backups.
- retention_
period_ intdays - The retention period for all the databases in this managed instance.
- transaction_
log_ intbackup_ minutes - The value indicating minutes between transaction log backups.
- differential
Backup NumberHours - The differential backup interval in hours.
- full
Backup NumberDays - The value indicating days between full backups.
- retention
Period NumberDays - The retention period for all the databases in this managed instance.
- transaction
Log NumberBackup Minutes - The value indicating minutes between transaction log backups.
EditionType, EditionTypeArgs
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- Edition
Type Evaluation - Evaluation
- Edition
Type Enterprise - Enterprise
- Edition
Type Standard - Standard
- Edition
Type Web - Web
- Edition
Type Developer - Developer
- Edition
Type Express - Express
- Edition
Type_Business_Intelligence - Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- EVALUATION
- Evaluation
- ENTERPRISE
- Enterprise
- STANDARD
- Standard
- WEB
- Web
- DEVELOPER
- Developer
- EXPRESS
- Express
- BUSINESS_INTELLIGENCE
- Business Intelligence
- "Evaluation"
- Evaluation
- "Enterprise"
- Enterprise
- "Standard"
- Standard
- "Web"
- Web
- "Developer"
- Developer
- "Express"
- Express
- "Business Intelligence"
- Business Intelligence
FailoverClusterResponse, FailoverClusterResponseArgs
- Host
Names This property is required. List<string> - The host names which are part of the SQL FCI resource group.
- Id
This property is required. string - The GUID of the SQL Server's underlying Failover Cluster.
- Network
Name This property is required. string - The network name to connect to the SQL FCI.
- Sql
Instance Ids This property is required. List<string> - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- Host
Names This property is required. []string - The host names which are part of the SQL FCI resource group.
- Id
This property is required. string - The GUID of the SQL Server's underlying Failover Cluster.
- Network
Name This property is required. string - The network name to connect to the SQL FCI.
- Sql
Instance Ids This property is required. []string - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
Names This property is required. List<String> - The host names which are part of the SQL FCI resource group.
- id
This property is required. String - The GUID of the SQL Server's underlying Failover Cluster.
- network
Name This property is required. String - The network name to connect to the SQL FCI.
- sql
Instance Ids This property is required. List<String> - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
Names This property is required. string[] - The host names which are part of the SQL FCI resource group.
- id
This property is required. string - The GUID of the SQL Server's underlying Failover Cluster.
- network
Name This property is required. string - The network name to connect to the SQL FCI.
- sql
Instance Ids This property is required. string[] - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host_
names This property is required. Sequence[str] - The host names which are part of the SQL FCI resource group.
- id
This property is required. str - The GUID of the SQL Server's underlying Failover Cluster.
- network_
name This property is required. str - The network name to connect to the SQL FCI.
- sql_
instance_ ids This property is required. Sequence[str] - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
Names This property is required. List<String> - The host names which are part of the SQL FCI resource group.
- id
This property is required. String - The GUID of the SQL Server's underlying Failover Cluster.
- network
Name This property is required. String - The network name to connect to the SQL FCI.
- sql
Instance Ids This property is required. List<String> - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
HostType, HostTypeArgs
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- Host
Type_Azure_Virtual_Machine - Azure Virtual Machine
- Host
Type_Azure_VMWare_Virtual_Machine - Azure VMWare Virtual Machine
- Host
Type_Azure_Kubernetes_Service - Azure Kubernetes Service
- Host
Type_AWS_VMWare_Virtual_Machine - AWS VMWare Virtual Machine
- Host
Type_AWS_Kubernetes_Service - AWS Kubernetes Service
- Host
Type_GCP_VMWare_Virtual_Machine - GCP VMWare Virtual Machine
- Host
Type_GCP_Kubernetes_Service - GCP Kubernetes Service
- Host
Type Container - Container
- Host
Type_Virtual_Machine - Virtual Machine
- Host
Type_Physical_Server - Physical Server
- Host
Type_AWS_Virtual_Machine - AWS Virtual Machine
- Host
Type_GCP_Virtual_Machine - GCP Virtual Machine
- Host
Type Other - Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- AZURE_VIRTUAL_MACHINE
- Azure Virtual Machine
- AZURE_VM_WARE_VIRTUAL_MACHINE
- Azure VMWare Virtual Machine
- AZURE_KUBERNETES_SERVICE
- Azure Kubernetes Service
- AW_S_VM_WARE_VIRTUAL_MACHINE
- AWS VMWare Virtual Machine
- AW_S_KUBERNETES_SERVICE
- AWS Kubernetes Service
- GC_P_VM_WARE_VIRTUAL_MACHINE
- GCP VMWare Virtual Machine
- GC_P_KUBERNETES_SERVICE
- GCP Kubernetes Service
- CONTAINER
- Container
- VIRTUAL_MACHINE
- Virtual Machine
- PHYSICAL_SERVER
- Physical Server
- AW_S_VIRTUAL_MACHINE
- AWS Virtual Machine
- GC_P_VIRTUAL_MACHINE
- GCP Virtual Machine
- OTHER
- Other
- "Azure Virtual Machine"
- Azure Virtual Machine
- "Azure VMWare Virtual Machine"
- Azure VMWare Virtual Machine
- "Azure Kubernetes Service"
- Azure Kubernetes Service
- "AWS VMWare Virtual Machine"
- AWS VMWare Virtual Machine
- "AWS Kubernetes Service"
- AWS Kubernetes Service
- "GCP VMWare Virtual Machine"
- GCP VMWare Virtual Machine
- "GCP Kubernetes Service"
- GCP Kubernetes Service
- "Container"
- Container
- "Virtual Machine"
- Virtual Machine
- "Physical Server"
- Physical Server
- "AWS Virtual Machine"
- AWS Virtual Machine
- "GCP Virtual Machine"
- GCP Virtual Machine
- "Other"
- Other
Monitoring, MonitoringArgs
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
MonitoringResponse, MonitoringResponseArgs
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
SqlServerInstanceProperties, SqlServerInstancePropertiesArgs
- Backup
Policy Pulumi.Azure Native. Azure Arc Data. Inputs. Backup Policy - The backup profile for the SQL server.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Edition
string | Pulumi.
Azure Native. Azure Arc Data. Edition Type - SQL Server edition.
- Host
Type string | Pulumi.Azure Native. Azure Arc Data. Host Type - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Monitoring
Pulumi.
Azure Native. Azure Arc Data. Inputs. Monitoring - The monitoring configuration.
- Upgrade
Locked stringUntil - 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.
- Version
string | Pulumi.
Azure Native. Azure Arc Data. Sql Version - SQL Server version.
- Backup
Policy BackupPolicy - The backup profile for the SQL server.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Edition
string | Edition
Type - SQL Server edition.
- Host
Type string | HostType - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Monitoring Monitoring
- The monitoring configuration.
- Upgrade
Locked stringUntil - 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.
- Version
string | Sql
Version - SQL Server version.
- backup
Policy BackupPolicy - The backup profile for the SQL server.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition
String | Edition
Type - SQL Server edition.
- host
Type String | HostType - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- monitoring Monitoring
- The monitoring configuration.
- upgrade
Locked StringUntil - 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.
- version
String | Sql
Version - SQL Server version.
- backup
Policy BackupPolicy - The backup profile for the SQL server.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition
string | Edition
Type - SQL Server edition.
- host
Type string | HostType - Type of host for Azure Arc SQL Server
- instance
Name string - SQL Server instance name.
- monitoring Monitoring
- The monitoring configuration.
- upgrade
Locked stringUntil - 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.
- version
string | Sql
Version - SQL Server version.
- backup_
policy BackupPolicy - The backup profile for the SQL server.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition
str | Edition
Type - SQL Server edition.
- host_
type str | HostType - Type of host for Azure Arc SQL Server
- instance_
name str - SQL Server instance name.
- monitoring Monitoring
- The monitoring configuration.
- upgrade_
locked_ struntil - 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.
- version
str | Sql
Version - SQL Server version.
- backup
Policy Property Map - The backup profile for the SQL server.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition String | "Evaluation" | "Enterprise" | "Standard" | "Web" | "Developer" | "Express" | "Business Intelligence"
- SQL Server edition.
- host
Type String | "Azure Virtual Machine" | "Azure VMWare Virtual Machine" | "Azure Kubernetes Service" | "AWS VMWare Virtual Machine" | "AWS Kubernetes Service" | "GCP VMWare Virtual Machine" | "GCP Kubernetes Service" | "Container" | "Virtual Machine" | "Physical Server" | "AWS Virtual Machine" | "GCP Virtual Machine" | "Other" - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- monitoring Property Map
- The monitoring configuration.
- upgrade
Locked StringUntil - 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.
- version String | "SQL Server 2012" | "SQL Server 2014" | "SQL Server 2016" | "SQL Server 2017" | "SQL Server 2019" | "SQL Server 2022" | "Unknown"
- SQL Server version.
SqlServerInstancePropertiesResponse, SqlServerInstancePropertiesResponseArgs
- Always
On Role This property is required. string - The role of the SQL Server, based on availability.
- Azure
Defender Status This property is required. string - Status of Azure Defender.
- Azure
Defender Status Last Updated This property is required. string - Timestamp of last Azure Defender status update.
- Collation
This property is required. string - SQL Server collation.
- Container
Resource Id This property is required. string - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time This property is required. string - The time when the resource was created.
- Current
Version This property is required. string - SQL Server current version.
- Last
Inventory Upload Time This property is required. string - The time when last successful inventory upload was performed.
- Last
Usage Upload Time This property is required. string - The time when last successful usage upload was performed.
- License
Type This property is required. string - SQL Server license type.
- Patch
Level This property is required. string - SQL Server update level.
- Product
Id This property is required. string - SQL Server product ID.
- Provisioning
State This property is required. string - The provisioning state of the Arc-enabled SQL Server resource.
- Status
This property is required. string - The cloud connectivity status.
- Tcp
Dynamic Ports This property is required. string - Dynamic TCP ports used by SQL Server.
- Tcp
Static Ports This property is required. string - Static TCP ports used by SQL Server.
- VCore
This property is required. string - The number of logical processors used by the SQL Server instance.
- Backup
Policy Pulumi.Azure Native. Azure Arc Data. Inputs. Backup Policy Response - The backup profile for the SQL server.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Edition string
- SQL Server edition.
- Failover
Cluster Pulumi.Azure Native. Azure Arc Data. Inputs. Failover Cluster Response - Failover Cluster Instance properties.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Monitoring
Pulumi.
Azure Native. Azure Arc Data. Inputs. Monitoring Response - The monitoring configuration.
- Upgrade
Locked stringUntil - 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.
- Version string
- SQL Server version.
- Always
On Role This property is required. string - The role of the SQL Server, based on availability.
- Azure
Defender Status This property is required. string - Status of Azure Defender.
- Azure
Defender Status Last Updated This property is required. string - Timestamp of last Azure Defender status update.
- Collation
This property is required. string - SQL Server collation.
- Container
Resource Id This property is required. string - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time This property is required. string - The time when the resource was created.
- Current
Version This property is required. string - SQL Server current version.
- Last
Inventory Upload Time This property is required. string - The time when last successful inventory upload was performed.
- Last
Usage Upload Time This property is required. string - The time when last successful usage upload was performed.
- License
Type This property is required. string - SQL Server license type.
- Patch
Level This property is required. string - SQL Server update level.
- Product
Id This property is required. string - SQL Server product ID.
- Provisioning
State This property is required. string - The provisioning state of the Arc-enabled SQL Server resource.
- Status
This property is required. string - The cloud connectivity status.
- Tcp
Dynamic Ports This property is required. string - Dynamic TCP ports used by SQL Server.
- Tcp
Static Ports This property is required. string - Static TCP ports used by SQL Server.
- VCore
This property is required. string - The number of logical processors used by the SQL Server instance.
- Backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Edition string
- SQL Server edition.
- Failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Monitoring
Monitoring
Response - The monitoring configuration.
- Upgrade
Locked stringUntil - 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.
- Version string
- SQL Server version.
- always
On Role This property is required. String - The role of the SQL Server, based on availability.
- azure
Defender Status This property is required. String - Status of Azure Defender.
- azure
Defender Status Last Updated This property is required. String - Timestamp of last Azure Defender status update.
- collation
This property is required. String - SQL Server collation.
- container
Resource Id This property is required. String - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time This property is required. String - The time when the resource was created.
- current
Version This property is required. String - SQL Server current version.
- last
Inventory Upload Time This property is required. String - The time when last successful inventory upload was performed.
- last
Usage Upload Time This property is required. String - The time when last successful usage upload was performed.
- license
Type This property is required. String - SQL Server license type.
- patch
Level This property is required. String - SQL Server update level.
- product
Id This property is required. String - SQL Server product ID.
- provisioning
State This property is required. String - The provisioning state of the Arc-enabled SQL Server resource.
- status
This property is required. String - The cloud connectivity status.
- tcp
Dynamic Ports This property is required. String - Dynamic TCP ports used by SQL Server.
- tcp
Static Ports This property is required. String - Static TCP ports used by SQL Server.
- v
Core This property is required. String - The number of logical processors used by the SQL Server instance.
- backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition String
- SQL Server edition.
- failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- monitoring
Monitoring
Response - The monitoring configuration.
- upgrade
Locked StringUntil - 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.
- version String
- SQL Server version.
- always
On Role This property is required. string - The role of the SQL Server, based on availability.
- azure
Defender Status This property is required. string - Status of Azure Defender.
- azure
Defender Status Last Updated This property is required. string - Timestamp of last Azure Defender status update.
- collation
This property is required. string - SQL Server collation.
- container
Resource Id This property is required. string - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time This property is required. string - The time when the resource was created.
- current
Version This property is required. string - SQL Server current version.
- last
Inventory Upload Time This property is required. string - The time when last successful inventory upload was performed.
- last
Usage Upload Time This property is required. string - The time when last successful usage upload was performed.
- license
Type This property is required. string - SQL Server license type.
- patch
Level This property is required. string - SQL Server update level.
- product
Id This property is required. string - SQL Server product ID.
- provisioning
State This property is required. string - The provisioning state of the Arc-enabled SQL Server resource.
- status
This property is required. string - The cloud connectivity status.
- tcp
Dynamic Ports This property is required. string - Dynamic TCP ports used by SQL Server.
- tcp
Static Ports This property is required. string - Static TCP ports used by SQL Server.
- v
Core This property is required. string - The number of logical processors used by the SQL Server instance.
- backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition string
- SQL Server edition.
- failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- host
Type string - Type of host for Azure Arc SQL Server
- instance
Name string - SQL Server instance name.
- monitoring
Monitoring
Response - The monitoring configuration.
- upgrade
Locked stringUntil - 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.
- version string
- SQL Server version.
- always_
on_ role This property is required. str - The role of the SQL Server, based on availability.
- azure_
defender_ status This property is required. str - Status of Azure Defender.
- azure_
defender_ status_ last_ updated This property is required. str - Timestamp of last Azure Defender status update.
- collation
This property is required. str - SQL Server collation.
- container_
resource_ id This property is required. str - ARM Resource id of the container resource (Azure Arc for Servers).
- create_
time This property is required. str - The time when the resource was created.
- current_
version This property is required. str - SQL Server current version.
- last_
inventory_ upload_ time This property is required. str - The time when last successful inventory upload was performed.
- last_
usage_ upload_ time This property is required. str - The time when last successful usage upload was performed.
- license_
type This property is required. str - SQL Server license type.
- patch_
level This property is required. str - SQL Server update level.
- product_
id This property is required. str - SQL Server product ID.
- provisioning_
state This property is required. str - The provisioning state of the Arc-enabled SQL Server resource.
- status
This property is required. str - The cloud connectivity status.
- tcp_
dynamic_ ports This property is required. str - Dynamic TCP ports used by SQL Server.
- tcp_
static_ ports This property is required. str - Static TCP ports used by SQL Server.
- v_
core This property is required. str - The number of logical processors used by the SQL Server instance.
- backup_
policy BackupPolicy Response - The backup profile for the SQL server.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition str
- SQL Server edition.
- failover_
cluster FailoverCluster Response - Failover Cluster Instance properties.
- host_
type str - Type of host for Azure Arc SQL Server
- instance_
name str - SQL Server instance name.
- monitoring
Monitoring
Response - The monitoring configuration.
- upgrade_
locked_ struntil - 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.
- version str
- SQL Server version.
- always
On Role This property is required. String - The role of the SQL Server, based on availability.
- azure
Defender Status This property is required. String - Status of Azure Defender.
- azure
Defender Status Last Updated This property is required. String - Timestamp of last Azure Defender status update.
- collation
This property is required. String - SQL Server collation.
- container
Resource Id This property is required. String - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time This property is required. String - The time when the resource was created.
- current
Version This property is required. String - SQL Server current version.
- last
Inventory Upload Time This property is required. String - The time when last successful inventory upload was performed.
- last
Usage Upload Time This property is required. String - The time when last successful usage upload was performed.
- license
Type This property is required. String - SQL Server license type.
- patch
Level This property is required. String - SQL Server update level.
- product
Id This property is required. String - SQL Server product ID.
- provisioning
State This property is required. String - The provisioning state of the Arc-enabled SQL Server resource.
- status
This property is required. String - The cloud connectivity status.
- tcp
Dynamic Ports This property is required. String - Dynamic TCP ports used by SQL Server.
- tcp
Static Ports This property is required. String - Static TCP ports used by SQL Server.
- v
Core This property is required. String - The number of logical processors used by the SQL Server instance.
- backup
Policy Property Map - The backup profile for the SQL server.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- edition String
- SQL Server edition.
- failover
Cluster Property Map - Failover Cluster Instance properties.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- monitoring Property Map
- The monitoring configuration.
- upgrade
Locked StringUntil - 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.
- version String
- SQL Server version.
SqlVersion, SqlVersionArgs
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- Sql
Version_SQL_Server_2012 - SQL Server 2012
- Sql
Version_SQL_Server_2014 - SQL Server 2014
- Sql
Version_SQL_Server_2016 - SQL Server 2016
- Sql
Version_SQL_Server_2017 - SQL Server 2017
- Sql
Version_SQL_Server_2019 - SQL Server 2019
- Sql
Version_SQL_Server_2022 - SQL Server 2022
- Sql
Version Unknown - Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQ_L_SERVER_2012
- SQL Server 2012
- SQ_L_SERVER_2014
- SQL Server 2014
- SQ_L_SERVER_2016
- SQL Server 2016
- SQ_L_SERVER_2017
- SQL Server 2017
- SQ_L_SERVER_2019
- SQL Server 2019
- SQ_L_SERVER_2022
- SQL Server 2022
- UNKNOWN
- Unknown
- "SQL Server 2012"
- SQL Server 2012
- "SQL Server 2014"
- SQL Server 2014
- "SQL Server 2016"
- SQL Server 2016
- "SQL Server 2017"
- SQL Server 2017
- "SQL Server 2019"
- SQL Server 2019
- "SQL Server 2022"
- SQL Server 2022
- "Unknown"
- Unknown
SystemDataResponse, SystemDataResponseArgs
- 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.
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:azurearcdata:SqlServerInstance testsqlServerInstance /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0