Sql Server Instance
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/#accessing-any-api-version-via-local-packages for details.
Example Usage
Updates a SQL Server Instance tags.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlServerInstance = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstance", new()
{
Location = "northeurope",
Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
{
BackupPolicy = new AzureNative.AzureArcData.Inputs.BackupPolicyArgs
{
DifferentialBackupHours = 12,
FullBackupDays = 1,
RetentionPeriodDays = 1,
TransactionLogBackupMinutes = 30,
},
Cores = "4",
Edition = AzureNative.AzureArcData.EditionType.Developer,
HostType = AzureNative.AzureArcData.HostType.Physical_Server,
InstanceName = "name of instance",
Monitoring = new AzureNative.AzureArcData.Inputs.MonitoringArgs
{
Enabled = false,
},
Version = AzureNative.AzureArcData.SqlVersion.SQL_Server_2012,
},
ResourceGroupName = "testrg",
SqlServerInstanceName = "testsqlServerInstance",
Tags =
{
{ "mytag", "myval" },
},
});
});
Content copied to clipboard
package main
import (
azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := azurearcdata.NewSqlServerInstance(ctx, "sqlServerInstance", &azurearcdata.SqlServerInstanceArgs{
Location: pulumi.String("northeurope"),
Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
BackupPolicy: &azurearcdata.BackupPolicyArgs{
DifferentialBackupHours: pulumi.Int(12),
FullBackupDays: pulumi.Int(1),
RetentionPeriodDays: pulumi.Int(1),
TransactionLogBackupMinutes: pulumi.Int(30),
},
Cores: pulumi.String("4"),
Edition: pulumi.String(azurearcdata.EditionTypeDeveloper),
HostType: pulumi.String(azurearcdata.HostType_Physical_Server),
InstanceName: pulumi.String("name of instance"),
Monitoring: &azurearcdata.MonitoringArgs{
Enabled: pulumi.Bool(false),
},
Version: pulumi.String(azurearcdata.SqlVersion_SQL_Server_2012),
},
ResourceGroupName: pulumi.String("testrg"),
SqlServerInstanceName: pulumi.String("testsqlServerInstance"),
Tags: pulumi.StringMap{
"mytag": pulumi.String("myval"),
},
})
if err != nil {
return err
}
return nil
})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.azurearcdata.SqlServerInstance;
import com.pulumi.azurenative.azurearcdata.SqlServerInstanceArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerInstancePropertiesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.BackupPolicyArgs;
import com.pulumi.azurenative.azurearcdata.inputs.MonitoringArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var sqlServerInstance = new SqlServerInstance("sqlServerInstance", SqlServerInstanceArgs.builder()
.location("northeurope")
.properties(SqlServerInstancePropertiesArgs.builder()
.backupPolicy(BackupPolicyArgs.builder()
.differentialBackupHours(12)
.fullBackupDays(1)
.retentionPeriodDays(1)
.transactionLogBackupMinutes(30)
.build())
.cores("4")
.edition("Developer")
.hostType("Physical Server")
.instanceName("name of instance")
.monitoring(MonitoringArgs.builder()
.enabled(false)
.build())
.version("SQL Server 2012")
.build())
.resourceGroupName("testrg")
.sqlServerInstanceName("testsqlServerInstance")
.tags(Map.of("mytag", "myval"))
.build());
}
}
Content copied to clipboard
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}
Content copied to clipboard