Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native
  3. API Docs
  4. azurearcdata
  5. SqlServerDatabase
This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
Azure Native v3.4.0 published on Wednesday, May 7, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native.azurearcdata.SqlServerDatabase

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
Azure Native v3.4.0 published on Wednesday, May 7, 2025 by Pulumi
pulumi/pulumi-azure-native

    Arc Sql Server database

    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.

    Example Usage

    Create a Arc Sql Server database.

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlServerDatabase = new AzureNative.AzureArcData.SqlServerDatabase("sqlServerDatabase", new()
    {
        DatabaseName = "testdb",
        Location = "southeastasia",
        Properties = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesArgs
        {
            BackupInformation = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesBackupInformationArgs
            {
                LastFullBackup = "2022-05-05T16:26:33.883Z",
                LastLogBackup = "2022-05-10T16:26:33.883Z",
            },
            BackupPolicy = new AzureNative.AzureArcData.Inputs.BackupPolicyArgs
            {
                DifferentialBackupHours = 12,
                FullBackupDays = 1,
                RetentionPeriodDays = 1,
                TransactionLogBackupMinutes = 30,
            },
            CollationName = "SQL_Latin1_General_CP1_CI_AS",
            CompatibilityLevel = 150,
            CreateMode = AzureNative.AzureArcData.DatabaseCreateMode.PointInTimeRestore,
            DatabaseCreationDate = "2022-04-05T16:26:33.883Z",
            DatabaseOptions = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs
            {
                IsAutoCloseOn = true,
                IsAutoCreateStatsOn = true,
                IsAutoShrinkOn = true,
                IsAutoUpdateStatsOn = true,
                IsEncrypted = true,
                IsMemoryOptimizationEnabled = true,
                IsRemoteDataArchiveEnabled = true,
                IsTrustworthyOn = true,
            },
            IsReadOnly = true,
            RecoveryMode = AzureNative.AzureArcData.RecoveryMode.Full,
            RestorePointInTime = "2022-05-05T16:26:33.883Z",
            SizeMB = 150,
            SourceDatabaseId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase",
            SpaceAvailableMB = 100,
            State = AzureNative.AzureArcData.DatabaseState.Online,
        },
        ResourceGroupName = "testrg",
        SqlServerInstanceName = "testSqlServerInstance",
        Tags = 
        {
            { "mytag", "myval" },
        },
    });

});

    package main

import (
	azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := azurearcdata.NewSqlServerDatabase(ctx, "sqlServerDatabase", &azurearcdata.SqlServerDatabaseArgs{
			DatabaseName: pulumi.String("testdb"),
			Location:     pulumi.String("southeastasia"),
			Properties: &azurearcdata.SqlServerDatabaseResourcePropertiesArgs{
				BackupInformation: &azurearcdata.SqlServerDatabaseResourcePropertiesBackupInformationArgs{
					LastFullBackup: pulumi.String("2022-05-05T16:26:33.883Z"),
					LastLogBackup:  pulumi.String("2022-05-10T16:26:33.883Z"),
				},
				BackupPolicy: &azurearcdata.BackupPolicyArgs{
					DifferentialBackupHours:     pulumi.Int(12),
					FullBackupDays:              pulumi.Int(1),
					RetentionPeriodDays:         pulumi.Int(1),
					TransactionLogBackupMinutes: pulumi.Int(30),
				},
				CollationName:        pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
				CompatibilityLevel:   pulumi.Int(150),
				CreateMode:           pulumi.String(azurearcdata.DatabaseCreateModePointInTimeRestore),
				DatabaseCreationDate: pulumi.String("2022-04-05T16:26:33.883Z"),
				DatabaseOptions: &azurearcdata.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs{
					IsAutoCloseOn:               pulumi.Bool(true),
					IsAutoCreateStatsOn:         pulumi.Bool(true),
					IsAutoShrinkOn:              pulumi.Bool(true),
					IsAutoUpdateStatsOn:         pulumi.Bool(true),
					IsEncrypted:                 pulumi.Bool(true),
					IsMemoryOptimizationEnabled: pulumi.Bool(true),
					IsRemoteDataArchiveEnabled:  pulumi.Bool(true),
					IsTrustworthyOn:             pulumi.Bool(true),
				},
				IsReadOnly:         pulumi.Bool(true),
				RecoveryMode:       pulumi.String(azurearcdata.RecoveryModeFull),
				RestorePointInTime: pulumi.String("2022-05-05T16:26:33.883Z"),
				SizeMB:             pulumi.Float64(150),
				SourceDatabaseId:   pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase"),
				SpaceAvailableMB:   pulumi.Float64(100),
				State:              pulumi.String(azurearcdata.DatabaseStateOnline),
			},
			ResourceGroupName:     pulumi.String("testrg"),
			SqlServerInstanceName: pulumi.String("testSqlServerInstance"),
			Tags: pulumi.StringMap{
				"mytag": pulumi.String("myval"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.azurearcdata.SqlServerDatabase;
import com.pulumi.azurenative.azurearcdata.SqlServerDatabaseArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesBackupInformationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.BackupPolicyArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs;
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 sqlServerDatabase = new SqlServerDatabase("sqlServerDatabase", SqlServerDatabaseArgs.builder()
            .databaseName("testdb")
            .location("southeastasia")
            .properties(SqlServerDatabaseResourcePropertiesArgs.builder()
                .backupInformation(SqlServerDatabaseResourcePropertiesBackupInformationArgs.builder()
                    .lastFullBackup("2022-05-05T16:26:33.883Z")
                    .lastLogBackup("2022-05-10T16:26:33.883Z")
                    .build())
                .backupPolicy(BackupPolicyArgs.builder()
                    .differentialBackupHours(12)
                    .fullBackupDays(1)
                    .retentionPeriodDays(1)
                    .transactionLogBackupMinutes(30)
                    .build())
                .collationName("SQL_Latin1_General_CP1_CI_AS")
                .compatibilityLevel(150)
                .createMode("PointInTimeRestore")
                .databaseCreationDate("2022-04-05T16:26:33.883Z")
                .databaseOptions(SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs.builder()
                    .isAutoCloseOn(true)
                    .isAutoCreateStatsOn(true)
                    .isAutoShrinkOn(true)
                    .isAutoUpdateStatsOn(true)
                    .isEncrypted(true)
                    .isMemoryOptimizationEnabled(true)
                    .isRemoteDataArchiveEnabled(true)
                    .isTrustworthyOn(true)
                    .build())
                .isReadOnly(true)
                .recoveryMode("Full")
                .restorePointInTime("2022-05-05T16:26:33.883Z")
                .sizeMB(150.0)
                .sourceDatabaseId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase")
                .spaceAvailableMB(100.0)
                .state("Online")
                .build())
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testSqlServerInstance")
            .tags(Map.of("mytag", "myval"))
            .build());

    }
}

    import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlServerDatabase = new azure_native.azurearcdata.SqlServerDatabase("sqlServerDatabase", {
    databaseName: "testdb",
    location: "southeastasia",
    properties: {
        backupInformation: {
            lastFullBackup: "2022-05-05T16:26:33.883Z",
            lastLogBackup: "2022-05-10T16:26:33.883Z",
        },
        backupPolicy: {
            differentialBackupHours: 12,
            fullBackupDays: 1,
            retentionPeriodDays: 1,
            transactionLogBackupMinutes: 30,
        },
        collationName: "SQL_Latin1_General_CP1_CI_AS",
        compatibilityLevel: 150,
        createMode: azure_native.azurearcdata.DatabaseCreateMode.PointInTimeRestore,
        databaseCreationDate: "2022-04-05T16:26:33.883Z",
        databaseOptions: {
            isAutoCloseOn: true,
            isAutoCreateStatsOn: true,
            isAutoShrinkOn: true,
            isAutoUpdateStatsOn: true,
            isEncrypted: true,
            isMemoryOptimizationEnabled: true,
            isRemoteDataArchiveEnabled: true,
            isTrustworthyOn: true,
        },
        isReadOnly: true,
        recoveryMode: azure_native.azurearcdata.RecoveryMode.Full,
        restorePointInTime: "2022-05-05T16:26:33.883Z",
        sizeMB: 150,
        sourceDatabaseId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase",
        spaceAvailableMB: 100,
        state: azure_native.azurearcdata.DatabaseState.Online,
    },
    resourceGroupName: "testrg",
    sqlServerInstanceName: "testSqlServerInstance",
    tags: {
        mytag: "myval",
    },
});

    import pulumi
import pulumi_azure_native as azure_native

sql_server_database = azure_native.azurearcdata.SqlServerDatabase("sqlServerDatabase",
    database_name="testdb",
    location="southeastasia",
    properties={
        "backup_information": {
            "last_full_backup": "2022-05-05T16:26:33.883Z",
            "last_log_backup": "2022-05-10T16:26:33.883Z",
        },
        "backup_policy": {
            "differential_backup_hours": 12,
            "full_backup_days": 1,
            "retention_period_days": 1,
            "transaction_log_backup_minutes": 30,
        },
        "collation_name": "SQL_Latin1_General_CP1_CI_AS",
        "compatibility_level": 150,
        "create_mode": azure_native.azurearcdata.DatabaseCreateMode.POINT_IN_TIME_RESTORE,
        "database_creation_date": "2022-04-05T16:26:33.883Z",
        "database_options": {
            "is_auto_close_on": True,
            "is_auto_create_stats_on": True,
            "is_auto_shrink_on": True,
            "is_auto_update_stats_on": True,
            "is_encrypted": True,
            "is_memory_optimization_enabled": True,
            "is_remote_data_archive_enabled": True,
            "is_trustworthy_on": True,
        },
        "is_read_only": True,
        "recovery_mode": azure_native.azurearcdata.RecoveryMode.FULL,
        "restore_point_in_time": "2022-05-05T16:26:33.883Z",
        "size_mb": 150,
        "source_database_id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase",
        "space_available_mb": 100,
        "state": azure_native.azurearcdata.DatabaseState.ONLINE,
    },
    resource_group_name="testrg",
    sql_server_instance_name="testSqlServerInstance",
    tags={
        "mytag": "myval",
    })

    resources:
  sqlServerDatabase:
    type: azure-native:azurearcdata:SqlServerDatabase
    properties:
      databaseName: testdb
      location: southeastasia
      properties:
        backupInformation:
          lastFullBackup: 2022-05-05T16:26:33.883Z
          lastLogBackup: 2022-05-10T16:26:33.883Z
        backupPolicy:
          differentialBackupHours: 12
          fullBackupDays: 1
          retentionPeriodDays: 1
          transactionLogBackupMinutes: 30
        collationName: SQL_Latin1_General_CP1_CI_AS
        compatibilityLevel: 150
        createMode: PointInTimeRestore
        databaseCreationDate: 2022-04-05T16:26:33.883Z
        databaseOptions:
          isAutoCloseOn: true
          isAutoCreateStatsOn: true
          isAutoShrinkOn: true
          isAutoUpdateStatsOn: true
          isEncrypted: true
          isMemoryOptimizationEnabled: true
          isRemoteDataArchiveEnabled: true
          isTrustworthyOn: true
        isReadOnly: true
        recoveryMode: Full
        restorePointInTime: 2022-05-05T16:26:33.883Z
        sizeMB: 150
        sourceDatabaseId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase
        spaceAvailableMB: 100
        state: Online
      resourceGroupName: testrg
      sqlServerInstanceName: testSqlServerInstance
      tags:
        mytag: myval

    Create SqlServerDatabase Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlServerDatabase(name: string, args: SqlServerDatabaseArgs, opts?: CustomResourceOptions);
    @overload
def SqlServerDatabase(resource_name: str,
                      args: SqlServerDatabaseArgs,
                      opts: Optional[ResourceOptions] = None)

@overload
def SqlServerDatabase(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      properties: Optional[SqlServerDatabaseResourcePropertiesArgs] = None,
                      resource_group_name: Optional[str] = None,
                      sql_server_instance_name: Optional[str] = None,
                      database_name: Optional[str] = None,
                      location: Optional[str] = None,
                      tags: Optional[Mapping[str, str]] = None)
    func NewSqlServerDatabase(ctx *Context, name string, args SqlServerDatabaseArgs, opts ...ResourceOption) (*SqlServerDatabase, error)
    public SqlServerDatabase(string name, SqlServerDatabaseArgs args, CustomResourceOptions? opts = null)
    public SqlServerDatabase(String name, SqlServerDatabaseArgs args)
public SqlServerDatabase(String name, SqlServerDatabaseArgs args, CustomResourceOptions options)

    type: azure-native:azurearcdata:SqlServerDatabase
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args SqlServerDatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlServerDatabaseArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlServerDatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlServerDatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlServerDatabaseArgs
    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 sqlServerDatabaseResource = new AzureNative.AzureArcData.SqlServerDatabase("sqlServerDatabaseResource", new()
{
    Properties = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesArgs
    {
        BackupInformation = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesBackupInformationArgs
        {
            LastFullBackup = "string",
            LastLogBackup = "string",
        },
        BackupPolicy = new AzureNative.AzureArcData.Inputs.BackupPolicyArgs
        {
            DifferentialBackupHours = 0,
            FullBackupDays = 0,
            RetentionPeriodDays = 0,
            TransactionLogBackupMinutes = 0,
        },
        CollationName = "string",
        CompatibilityLevel = 0,
        CreateMode = "string",
        DatabaseCreationDate = "string",
        DatabaseOptions = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs
        {
            IsAutoCloseOn = false,
            IsAutoCreateStatsOn = false,
            IsAutoShrinkOn = false,
            IsAutoUpdateStatsOn = false,
            IsEncrypted = false,
            IsMemoryOptimizationEnabled = false,
            IsRemoteDataArchiveEnabled = false,
            IsTrustworthyOn = false,
        },
        IsReadOnly = false,
        RecoveryMode = "string",
        RestorePointInTime = "string",
        SizeMB = 0,
        SourceDatabaseId = "string",
        SpaceAvailableMB = 0,
        State = "string",
    },
    ResourceGroupName = "string",
    SqlServerInstanceName = "string",
    DatabaseName = "string",
    Location = "string",
    Tags = 
    {
        { "string", "string" },
    },
});

    example, err := azurearcdata.NewSqlServerDatabase(ctx, "sqlServerDatabaseResource", &azurearcdata.SqlServerDatabaseArgs{
	Properties: &azurearcdata.SqlServerDatabaseResourcePropertiesArgs{
		BackupInformation: &azurearcdata.SqlServerDatabaseResourcePropertiesBackupInformationArgs{
			LastFullBackup: pulumi.String("string"),
			LastLogBackup:  pulumi.String("string"),
		},
		BackupPolicy: &azurearcdata.BackupPolicyArgs{
			DifferentialBackupHours:     pulumi.Int(0),
			FullBackupDays:              pulumi.Int(0),
			RetentionPeriodDays:         pulumi.Int(0),
			TransactionLogBackupMinutes: pulumi.Int(0),
		},
		CollationName:        pulumi.String("string"),
		CompatibilityLevel:   pulumi.Int(0),
		CreateMode:           pulumi.String("string"),
		DatabaseCreationDate: pulumi.String("string"),
		DatabaseOptions: &azurearcdata.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs{
			IsAutoCloseOn:               pulumi.Bool(false),
			IsAutoCreateStatsOn:         pulumi.Bool(false),
			IsAutoShrinkOn:              pulumi.Bool(false),
			IsAutoUpdateStatsOn:         pulumi.Bool(false),
			IsEncrypted:                 pulumi.Bool(false),
			IsMemoryOptimizationEnabled: pulumi.Bool(false),
			IsRemoteDataArchiveEnabled:  pulumi.Bool(false),
			IsTrustworthyOn:             pulumi.Bool(false),
		},
		IsReadOnly:         pulumi.Bool(false),
		RecoveryMode:       pulumi.String("string"),
		RestorePointInTime: pulumi.String("string"),
		SizeMB:             pulumi.Float64(0),
		SourceDatabaseId:   pulumi.String("string"),
		SpaceAvailableMB:   pulumi.Float64(0),
		State:              pulumi.String("string"),
	},
	ResourceGroupName:     pulumi.String("string"),
	SqlServerInstanceName: pulumi.String("string"),
	DatabaseName:          pulumi.String("string"),
	Location:              pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})

    var sqlServerDatabaseResource = new SqlServerDatabase("sqlServerDatabaseResource", SqlServerDatabaseArgs.builder()
    .properties(SqlServerDatabaseResourcePropertiesArgs.builder()
        .backupInformation(SqlServerDatabaseResourcePropertiesBackupInformationArgs.builder()
            .lastFullBackup("string")
            .lastLogBackup("string")
            .build())
        .backupPolicy(BackupPolicyArgs.builder()
            .differentialBackupHours(0)
            .fullBackupDays(0)
            .retentionPeriodDays(0)
            .transactionLogBackupMinutes(0)
            .build())
        .collationName("string")
        .compatibilityLevel(0)
        .createMode("string")
        .databaseCreationDate("string")
        .databaseOptions(SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs.builder()
            .isAutoCloseOn(false)
            .isAutoCreateStatsOn(false)
            .isAutoShrinkOn(false)
            .isAutoUpdateStatsOn(false)
            .isEncrypted(false)
            .isMemoryOptimizationEnabled(false)
            .isRemoteDataArchiveEnabled(false)
            .isTrustworthyOn(false)
            .build())
        .isReadOnly(false)
        .recoveryMode("string")
        .restorePointInTime("string")
        .sizeMB(0.0)
        .sourceDatabaseId("string")
        .spaceAvailableMB(0.0)
        .state("string")
        .build())
    .resourceGroupName("string")
    .sqlServerInstanceName("string")
    .databaseName("string")
    .location("string")
    .tags(Map.of("string", "string"))
    .build());

    sql_server_database_resource = azure_native.azurearcdata.SqlServerDatabase("sqlServerDatabaseResource",
    properties={
        "backup_information": {
            "last_full_backup": "string",
            "last_log_backup": "string",
        },
        "backup_policy": {
            "differential_backup_hours": 0,
            "full_backup_days": 0,
            "retention_period_days": 0,
            "transaction_log_backup_minutes": 0,
        },
        "collation_name": "string",
        "compatibility_level": 0,
        "create_mode": "string",
        "database_creation_date": "string",
        "database_options": {
            "is_auto_close_on": False,
            "is_auto_create_stats_on": False,
            "is_auto_shrink_on": False,
            "is_auto_update_stats_on": False,
            "is_encrypted": False,
            "is_memory_optimization_enabled": False,
            "is_remote_data_archive_enabled": False,
            "is_trustworthy_on": False,
        },
        "is_read_only": False,
        "recovery_mode": "string",
        "restore_point_in_time": "string",
        "size_mb": 0,
        "source_database_id": "string",
        "space_available_mb": 0,
        "state": "string",
    },
    resource_group_name="string",
    sql_server_instance_name="string",
    database_name="string",
    location="string",
    tags={
        "string": "string",
    })

    const sqlServerDatabaseResource = new azure_native.azurearcdata.SqlServerDatabase("sqlServerDatabaseResource", {
    properties: {
        backupInformation: {
            lastFullBackup: "string",
            lastLogBackup: "string",
        },
        backupPolicy: {
            differentialBackupHours: 0,
            fullBackupDays: 0,
            retentionPeriodDays: 0,
            transactionLogBackupMinutes: 0,
        },
        collationName: "string",
        compatibilityLevel: 0,
        createMode: "string",
        databaseCreationDate: "string",
        databaseOptions: {
            isAutoCloseOn: false,
            isAutoCreateStatsOn: false,
            isAutoShrinkOn: false,
            isAutoUpdateStatsOn: false,
            isEncrypted: false,
            isMemoryOptimizationEnabled: false,
            isRemoteDataArchiveEnabled: false,
            isTrustworthyOn: false,
        },
        isReadOnly: false,
        recoveryMode: "string",
        restorePointInTime: "string",
        sizeMB: 0,
        sourceDatabaseId: "string",
        spaceAvailableMB: 0,
        state: "string",
    },
    resourceGroupName: "string",
    sqlServerInstanceName: "string",
    databaseName: "string",
    location: "string",
    tags: {
        string: "string",
    },
});

    type: azure-native:azurearcdata:SqlServerDatabase
properties:
    databaseName: string
    location: string
    properties:
        backupInformation:
            lastFullBackup: string
            lastLogBackup: string
        backupPolicy:
            differentialBackupHours: 0
            fullBackupDays: 0
            retentionPeriodDays: 0
            transactionLogBackupMinutes: 0
        collationName: string
        compatibilityLevel: 0
        createMode: string
        databaseCreationDate: string
        databaseOptions:
            isAutoCloseOn: false
            isAutoCreateStatsOn: false
            isAutoShrinkOn: false
            isAutoUpdateStatsOn: false
            isEncrypted: false
            isMemoryOptimizationEnabled: false
            isRemoteDataArchiveEnabled: false
            isTrustworthyOn: false
        isReadOnly: false
        recoveryMode: string
        restorePointInTime: string
        sizeMB: 0
        sourceDatabaseId: string
        spaceAvailableMB: 0
        state: string
    resourceGroupName: string
    sqlServerInstanceName: string
    tags:
        string: string

    SqlServerDatabase 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 SqlServerDatabase resource accepts the following input properties:

    Properties Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourceProperties
    Properties of Arc Sql Server database
    ResourceGroupName string
    The name of the Azure resource group
    SqlServerInstanceName string
    Name of SQL Server Instance
    DatabaseName string
    Name of the database
    Location string
    The geo-location where the resource lives
    Tags Dictionary<string, string>
    Resource tags.
    Properties SqlServerDatabaseResourcePropertiesArgs
    Properties of Arc Sql Server database
    ResourceGroupName string
    The name of the Azure resource group
    SqlServerInstanceName string
    Name of SQL Server Instance
    DatabaseName string
    Name of the database
    Location string
    The geo-location where the resource lives
    Tags map[string]string
    Resource tags.
    properties SqlServerDatabaseResourceProperties
    Properties of Arc Sql Server database
    resourceGroupName String
    The name of the Azure resource group
    sqlServerInstanceName String
    Name of SQL Server Instance
    databaseName String
    Name of the database
    location String
    The geo-location where the resource lives
    tags Map<String,String>
    Resource tags.
    properties SqlServerDatabaseResourceProperties
    Properties of Arc Sql Server database
    resourceGroupName string
    The name of the Azure resource group
    sqlServerInstanceName string
    Name of SQL Server Instance
    databaseName string
    Name of the database
    location string
    The geo-location where the resource lives
    tags {[key: string]: string}
    Resource tags.
    properties SqlServerDatabaseResourcePropertiesArgs
    Properties of Arc Sql Server database
    resource_group_name str
    The name of the Azure resource group
    sql_server_instance_name str
    Name of SQL Server Instance
    database_name str
    Name of the database
    location str
    The geo-location where the resource lives
    tags Mapping[str, str]
    Resource tags.
    properties Property Map
    Properties of Arc Sql Server database
    resourceGroupName String
    The name of the Azure resource group
    sqlServerInstanceName String
    Name of SQL Server Instance
    databaseName String
    Name of the database
    location String
    The geo-location where the resource lives
    tags Map<String>
    Resource tags.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SqlServerDatabase resource produces the following output properties:

    AzureApiVersion string
    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
    SystemData Pulumi.AzureNative.AzureArcData.Outputs.SystemDataResponse
    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"
    AzureApiVersion string
    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
    SystemData SystemDataResponse
    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"
    azureApiVersion String
    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
    systemData SystemDataResponse
    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"
    azureApiVersion string
    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
    systemData SystemDataResponse
    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_version str
    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 SystemDataResponse
    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"
    azureApiVersion String
    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
    systemData 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

    DifferentialBackupHours int
    The differential backup interval in hours.
    FullBackupDays int
    The value indicating days between full backups.
    RetentionPeriodDays int
    The retention period for all the databases in this managed instance.
    TransactionLogBackupMinutes int
    The value indicating minutes between transaction log backups.
    DifferentialBackupHours int
    The differential backup interval in hours.
    FullBackupDays int
    The value indicating days between full backups.
    RetentionPeriodDays int
    The retention period for all the databases in this managed instance.
    TransactionLogBackupMinutes int
    The value indicating minutes between transaction log backups.
    differentialBackupHours Integer
    The differential backup interval in hours.
    fullBackupDays Integer
    The value indicating days between full backups.
    retentionPeriodDays Integer
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes Integer
    The value indicating minutes between transaction log backups.
    differentialBackupHours number
    The differential backup interval in hours.
    fullBackupDays number
    The value indicating days between full backups.
    retentionPeriodDays number
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes number
    The value indicating minutes between transaction log backups.
    differential_backup_hours int
    The differential backup interval in hours.
    full_backup_days int
    The value indicating days between full backups.
    retention_period_days int
    The retention period for all the databases in this managed instance.
    transaction_log_backup_minutes int
    The value indicating minutes between transaction log backups.
    differentialBackupHours Number
    The differential backup interval in hours.
    fullBackupDays Number
    The value indicating days between full backups.
    retentionPeriodDays Number
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes Number
    The value indicating minutes between transaction log backups.

    BackupPolicyResponse, BackupPolicyResponseArgs

    DifferentialBackupHours int
    The differential backup interval in hours.
    FullBackupDays int
    The value indicating days between full backups.
    RetentionPeriodDays int
    The retention period for all the databases in this managed instance.
    TransactionLogBackupMinutes int
    The value indicating minutes between transaction log backups.
    DifferentialBackupHours int
    The differential backup interval in hours.
    FullBackupDays int
    The value indicating days between full backups.
    RetentionPeriodDays int
    The retention period for all the databases in this managed instance.
    TransactionLogBackupMinutes int
    The value indicating minutes between transaction log backups.
    differentialBackupHours Integer
    The differential backup interval in hours.
    fullBackupDays Integer
    The value indicating days between full backups.
    retentionPeriodDays Integer
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes Integer
    The value indicating minutes between transaction log backups.
    differentialBackupHours number
    The differential backup interval in hours.
    fullBackupDays number
    The value indicating days between full backups.
    retentionPeriodDays number
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes number
    The value indicating minutes between transaction log backups.
    differential_backup_hours int
    The differential backup interval in hours.
    full_backup_days int
    The value indicating days between full backups.
    retention_period_days int
    The retention period for all the databases in this managed instance.
    transaction_log_backup_minutes int
    The value indicating minutes between transaction log backups.
    differentialBackupHours Number
    The differential backup interval in hours.
    fullBackupDays Number
    The value indicating days between full backups.
    retentionPeriodDays Number
    The retention period for all the databases in this managed instance.
    transactionLogBackupMinutes Number
    The value indicating minutes between transaction log backups.

    DatabaseCreateMode, DatabaseCreateModeArgs

    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    DatabaseCreateModeDefault
    Default
    DatabaseCreateModePointInTimeRestore
    PointInTimeRestore
    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    DEFAULT
    Default
    POINT_IN_TIME_RESTORE
    PointInTimeRestore
    "Default"
    Default
    "PointInTimeRestore"
    PointInTimeRestore

    DatabaseState, DatabaseStateArgs

    Online
    Online
    Restoring
    Restoring
    Recovering
    Recovering
    RecoveryPending
    RecoveryPending
    Suspect
    Suspect
    Emergency
    Emergency
    Offline
    Offline
    Copying
    Copying
    OfflineSecondary
    OfflineSecondary
    DatabaseStateOnline
    Online
    DatabaseStateRestoring
    Restoring
    DatabaseStateRecovering
    Recovering
    DatabaseStateRecoveryPending
    RecoveryPending
    DatabaseStateSuspect
    Suspect
    DatabaseStateEmergency
    Emergency
    DatabaseStateOffline
    Offline
    DatabaseStateCopying
    Copying
    DatabaseStateOfflineSecondary
    OfflineSecondary
    Online
    Online
    Restoring
    Restoring
    Recovering
    Recovering
    RecoveryPending
    RecoveryPending
    Suspect
    Suspect
    Emergency
    Emergency
    Offline
    Offline
    Copying
    Copying
    OfflineSecondary
    OfflineSecondary
    Online
    Online
    Restoring
    Restoring
    Recovering
    Recovering
    RecoveryPending
    RecoveryPending
    Suspect
    Suspect
    Emergency
    Emergency
    Offline
    Offline
    Copying
    Copying
    OfflineSecondary
    OfflineSecondary
    ONLINE
    Online
    RESTORING
    Restoring
    RECOVERING
    Recovering
    RECOVERY_PENDING
    RecoveryPending
    SUSPECT
    Suspect
    EMERGENCY
    Emergency
    OFFLINE
    Offline
    COPYING
    Copying
    OFFLINE_SECONDARY
    OfflineSecondary
    "Online"
    Online
    "Restoring"
    Restoring
    "Recovering"
    Recovering
    "RecoveryPending"
    RecoveryPending
    "Suspect"
    Suspect
    "Emergency"
    Emergency
    "Offline"
    Offline
    "Copying"
    Copying
    "OfflineSecondary"
    OfflineSecondary

    RecoveryMode, RecoveryModeArgs

    Full
    Full
    Bulk_logged
    Bulk-logged
    Simple
    Simple
    RecoveryModeFull
    Full
    RecoveryMode_Bulk_Logged
    Bulk-logged
    RecoveryModeSimple
    Simple
    Full
    Full
    Bulklogged
    Bulk-logged
    Simple
    Simple
    Full
    Full
    Bulk_logged
    Bulk-logged
    Simple
    Simple
    FULL
    Full
    BULK_LOGGED
    Bulk-logged
    SIMPLE
    Simple
    "Full"
    Full
    "Bulk-logged"
    Bulk-logged
    "Simple"
    Simple

    SqlServerDatabaseResourceProperties, SqlServerDatabaseResourcePropertiesArgs

    BackupInformation Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesBackupInformation
    BackupPolicy Pulumi.AzureNative.AzureArcData.Inputs.BackupPolicy
    The backup profile for the SQL server.
    CollationName string
    Collation of the database.
    CompatibilityLevel int
    Compatibility level of the database
    CreateMode string | Pulumi.AzureNative.AzureArcData.DatabaseCreateMode
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    DatabaseCreationDate string
    Creation date of the database.
    DatabaseOptions Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesDatabaseOptions
    List of features that are enabled for the database
    IsReadOnly bool
    Whether the database is read only or not.
    RecoveryMode string | Pulumi.AzureNative.AzureArcData.RecoveryMode
    Status of the database.
    RestorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    SizeMB double
    Size of the database.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    SpaceAvailableMB double
    Space left of the database.
    State string | Pulumi.AzureNative.AzureArcData.DatabaseState
    State of the database.
    BackupInformation SqlServerDatabaseResourcePropertiesBackupInformation
    BackupPolicy BackupPolicy
    The backup profile for the SQL server.
    CollationName string
    Collation of the database.
    CompatibilityLevel int
    Compatibility level of the database
    CreateMode string | DatabaseCreateMode
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    DatabaseCreationDate string
    Creation date of the database.
    DatabaseOptions SqlServerDatabaseResourcePropertiesDatabaseOptions
    List of features that are enabled for the database
    IsReadOnly bool
    Whether the database is read only or not.
    RecoveryMode string | RecoveryMode
    Status of the database.
    RestorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    SizeMB float64
    Size of the database.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    SpaceAvailableMB float64
    Space left of the database.
    State string | DatabaseState
    State of the database.
    backupInformation SqlServerDatabaseResourcePropertiesBackupInformation
    backupPolicy BackupPolicy
    The backup profile for the SQL server.
    collationName String
    Collation of the database.
    compatibilityLevel Integer
    Compatibility level of the database
    createMode String | DatabaseCreateMode
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate String
    Creation date of the database.
    databaseOptions SqlServerDatabaseResourcePropertiesDatabaseOptions
    List of features that are enabled for the database
    isReadOnly Boolean
    Whether the database is read only or not.
    recoveryMode String | RecoveryMode
    Status of the database.
    restorePointInTime String
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB Double
    Size of the database.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB Double
    Space left of the database.
    state String | DatabaseState
    State of the database.
    backupInformation SqlServerDatabaseResourcePropertiesBackupInformation
    backupPolicy BackupPolicy
    The backup profile for the SQL server.
    collationName string
    Collation of the database.
    compatibilityLevel number
    Compatibility level of the database
    createMode string | DatabaseCreateMode
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate string
    Creation date of the database.
    databaseOptions SqlServerDatabaseResourcePropertiesDatabaseOptions
    List of features that are enabled for the database
    isReadOnly boolean
    Whether the database is read only or not.
    recoveryMode string | RecoveryMode
    Status of the database.
    restorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB number
    Size of the database.
    sourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB number
    Space left of the database.
    state string | DatabaseState
    State of the database.
    backup_information SqlServerDatabaseResourcePropertiesBackupInformation
    backup_policy BackupPolicy
    The backup profile for the SQL server.
    collation_name str
    Collation of the database.
    compatibility_level int
    Compatibility level of the database
    create_mode str | DatabaseCreateMode
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    database_creation_date str
    Creation date of the database.
    database_options SqlServerDatabaseResourcePropertiesDatabaseOptions
    List of features that are enabled for the database
    is_read_only bool
    Whether the database is read only or not.
    recovery_mode str | RecoveryMode
    Status of the database.
    restore_point_in_time str
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    size_mb float
    Size of the database.
    source_database_id str
    The resource identifier of the source database associated with create operation of this database.
    space_available_mb float
    Space left of the database.
    state str | DatabaseState
    State of the database.
    backupInformation Property Map
    backupPolicy Property Map
    The backup profile for the SQL server.
    collationName String
    Collation of the database.
    compatibilityLevel Number
    Compatibility level of the database
    createMode String | "Default" | "PointInTimeRestore"
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate String
    Creation date of the database.
    databaseOptions Property Map
    List of features that are enabled for the database
    isReadOnly Boolean
    Whether the database is read only or not.
    recoveryMode String | "Full" | "Bulk-logged" | "Simple"
    Status of the database.
    restorePointInTime String
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB Number
    Size of the database.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB Number
    Space left of the database.
    state String | "Online" | "Restoring" | "Recovering" | "RecoveryPending" | "Suspect" | "Emergency" | "Offline" | "Copying" | "OfflineSecondary"
    State of the database.

    SqlServerDatabaseResourcePropertiesBackupInformation, SqlServerDatabaseResourcePropertiesBackupInformationArgs

    LastFullBackup string
    Date time of last full backup.
    LastLogBackup string
    Date time of last log backup.
    LastFullBackup string
    Date time of last full backup.
    LastLogBackup string
    Date time of last log backup.
    lastFullBackup String
    Date time of last full backup.
    lastLogBackup String
    Date time of last log backup.
    lastFullBackup string
    Date time of last full backup.
    lastLogBackup string
    Date time of last log backup.
    last_full_backup str
    Date time of last full backup.
    last_log_backup str
    Date time of last log backup.
    lastFullBackup String
    Date time of last full backup.
    lastLogBackup String
    Date time of last log backup.

    SqlServerDatabaseResourcePropertiesDatabaseOptions, SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs

    SqlServerDatabaseResourcePropertiesResponse, SqlServerDatabaseResourcePropertiesResponseArgs

    EarliestRestoreDate string
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    LastDatabaseUploadTime string
    The time when last successful database upload was performed.
    ProvisioningState string
    The provisioning state of the Arc-enabled SQL Server database resource.
    BackupInformation Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesResponseBackupInformation
    BackupPolicy Pulumi.AzureNative.AzureArcData.Inputs.BackupPolicyResponse
    The backup profile for the SQL server.
    CollationName string
    Collation of the database.
    CompatibilityLevel int
    Compatibility level of the database
    CreateMode string
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    DatabaseCreationDate string
    Creation date of the database.
    DatabaseOptions Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
    List of features that are enabled for the database
    IsReadOnly bool
    Whether the database is read only or not.
    RecoveryMode string
    Status of the database.
    RestorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    SizeMB double
    Size of the database.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    SpaceAvailableMB double
    Space left of the database.
    State string
    State of the database.
    EarliestRestoreDate string
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    LastDatabaseUploadTime string
    The time when last successful database upload was performed.
    ProvisioningState string
    The provisioning state of the Arc-enabled SQL Server database resource.
    BackupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
    BackupPolicy BackupPolicyResponse
    The backup profile for the SQL server.
    CollationName string
    Collation of the database.
    CompatibilityLevel int
    Compatibility level of the database
    CreateMode string
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    DatabaseCreationDate string
    Creation date of the database.
    DatabaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
    List of features that are enabled for the database
    IsReadOnly bool
    Whether the database is read only or not.
    RecoveryMode string
    Status of the database.
    RestorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    SizeMB float64
    Size of the database.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    SpaceAvailableMB float64
    Space left of the database.
    State string
    State of the database.
    earliestRestoreDate String
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    lastDatabaseUploadTime String
    The time when last successful database upload was performed.
    provisioningState String
    The provisioning state of the Arc-enabled SQL Server database resource.
    backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
    backupPolicy BackupPolicyResponse
    The backup profile for the SQL server.
    collationName String
    Collation of the database.
    compatibilityLevel Integer
    Compatibility level of the database
    createMode String
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate String
    Creation date of the database.
    databaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
    List of features that are enabled for the database
    isReadOnly Boolean
    Whether the database is read only or not.
    recoveryMode String
    Status of the database.
    restorePointInTime String
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB Double
    Size of the database.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB Double
    Space left of the database.
    state String
    State of the database.
    earliestRestoreDate string
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    lastDatabaseUploadTime string
    The time when last successful database upload was performed.
    provisioningState string
    The provisioning state of the Arc-enabled SQL Server database resource.
    backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
    backupPolicy BackupPolicyResponse
    The backup profile for the SQL server.
    collationName string
    Collation of the database.
    compatibilityLevel number
    Compatibility level of the database
    createMode string
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate string
    Creation date of the database.
    databaseOptions SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
    List of features that are enabled for the database
    isReadOnly boolean
    Whether the database is read only or not.
    recoveryMode string
    Status of the database.
    restorePointInTime string
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB number
    Size of the database.
    sourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB number
    Space left of the database.
    state string
    State of the database.
    earliest_restore_date str
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    last_database_upload_time str
    The time when last successful database upload was performed.
    provisioning_state str
    The provisioning state of the Arc-enabled SQL Server database resource.
    backup_information SqlServerDatabaseResourcePropertiesResponseBackupInformation
    backup_policy BackupPolicyResponse
    The backup profile for the SQL server.
    collation_name str
    Collation of the database.
    compatibility_level int
    Compatibility level of the database
    create_mode str
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    database_creation_date str
    Creation date of the database.
    database_options SqlServerDatabaseResourcePropertiesResponseDatabaseOptions
    List of features that are enabled for the database
    is_read_only bool
    Whether the database is read only or not.
    recovery_mode str
    Status of the database.
    restore_point_in_time str
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    size_mb float
    Size of the database.
    source_database_id str
    The resource identifier of the source database associated with create operation of this database.
    space_available_mb float
    Space left of the database.
    state str
    State of the database.
    earliestRestoreDate String
    This records the earliest start date and time that restore is available for this database (ISO8601 format).
    lastDatabaseUploadTime String
    The time when last successful database upload was performed.
    provisioningState String
    The provisioning state of the Arc-enabled SQL Server database resource.
    backupInformation Property Map
    backupPolicy Property Map
    The backup profile for the SQL server.
    collationName String
    Collation of the database.
    compatibilityLevel Number
    Compatibility level of the database
    createMode String
    Database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. sourceDatabaseId and restorePointInTime must be specified.
    databaseCreationDate String
    Creation date of the database.
    databaseOptions Property Map
    List of features that are enabled for the database
    isReadOnly Boolean
    Whether the database is read only or not.
    recoveryMode String
    Status of the database.
    restorePointInTime String
    Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    sizeMB Number
    Size of the database.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    spaceAvailableMB Number
    Space left of the database.
    state String
    State of the database.

    SqlServerDatabaseResourcePropertiesResponseBackupInformation, SqlServerDatabaseResourcePropertiesResponseBackupInformationArgs

    LastFullBackup string
    Date time of last full backup.
    LastLogBackup string
    Date time of last log backup.
    LastFullBackup string
    Date time of last full backup.
    LastLogBackup string
    Date time of last log backup.
    lastFullBackup String
    Date time of last full backup.
    lastLogBackup String
    Date time of last log backup.
    lastFullBackup string
    Date time of last full backup.
    lastLogBackup string
    Date time of last log backup.
    last_full_backup str
    Date time of last full backup.
    last_log_backup str
    Date time of last log backup.
    lastFullBackup String
    Date time of last full backup.
    lastLogBackup String
    Date time of last log backup.

    SqlServerDatabaseResourcePropertiesResponseDatabaseOptions, SqlServerDatabaseResourcePropertiesResponseDatabaseOptionsArgs

    SystemDataResponse, SystemDataResponseArgs

    CreatedAt string
    The timestamp of resource creation (UTC).
    CreatedBy string
    The identity that created the resource.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    The type of identity that last modified the resource.
    CreatedAt string
    The timestamp of resource creation (UTC).
    CreatedBy string
    The identity that created the resource.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    The type of identity that last modified the resource.
    createdAt String
    The timestamp of resource creation (UTC).
    createdBy String
    The identity that created the resource.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    The type of identity that last modified the resource.
    createdAt string
    The timestamp of resource creation (UTC).
    createdBy string
    The identity that created the resource.
    createdByType string
    The type of identity that created the resource.
    lastModifiedAt string
    The timestamp of resource last modification (UTC)
    lastModifiedBy string
    The identity that last modified the resource.
    lastModifiedByType string
    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_type str
    The type of identity that created the resource.
    last_modified_at str
    The timestamp of resource last modification (UTC)
    last_modified_by str
    The identity that last modified the resource.
    last_modified_by_type str
    The type of identity that last modified the resource.
    createdAt String
    The timestamp of resource creation (UTC).
    createdBy String
    The identity that created the resource.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    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:SqlServerDatabase testdb /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}/databases/{databaseName}

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.
    Azure Native v3.4.0 published on Wednesday, May 7, 2025 by Pulumi
    pulumi/pulumi-azure-native