Azure Native v2.39.0, Apr 29 24

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.39.0 published on Monday, Apr 29, 2024 by Pulumi

pulumi/pulumi-azure-native

azure-native.azurearcdata.SqlServerDatabase

Explore with Pulumi AI

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.39.0 published on Monday, Apr 29, 2024 by Pulumi

pulumi/pulumi-azure-native

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",
            },
            CollationName = "SQL_Latin1_General_CP1_CI_AS",
            CompatibilityLevel = 150,
            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,
            SizeMB = 150,
            SpaceAvailableMB = 100,
            State = AzureNative.AzureArcData.DatabaseState.Online,
        },
        ResourceGroupName = "testrg",
        SqlServerInstanceName = "testSqlServerInstance",
        Tags = 
        {
            { "mytag", "myval" },
        },
    });

});

package main

import (
	"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.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"),
				},
				CollationName:        pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
				CompatibilityLevel:   pulumi.Int(150),
				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),
				SizeMB:           pulumi.Float64(150),
				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.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())
                .collationName("SQL_Latin1_General_CP1_CI_AS")
                .compatibilityLevel(150)
                .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")
                .sizeMB(150)
                .spaceAvailableMB(100)
                .state("Online")
                .build())
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testSqlServerInstance")
            .tags(Map.of("mytag", "myval"))
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

sql_server_database = azure_native.azurearcdata.SqlServerDatabase("sqlServerDatabase",
    database_name="testdb",
    location="southeastasia",
    properties=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesArgs(
        backup_information=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesBackupInformationArgs(
            last_full_backup="2022-05-05T16:26:33.883Z",
            last_log_backup="2022-05-10T16:26:33.883Z",
        ),
        collation_name="SQL_Latin1_General_CP1_CI_AS",
        compatibility_level=150,
        database_creation_date="2022-04-05T16:26:33.883Z",
        database_options=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs(
            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,
        size_mb=150,
        space_available_mb=100,
        state=azure_native.azurearcdata.DatabaseState.ONLINE,
    ),
    resource_group_name="testrg",
    sql_server_instance_name="testSqlServerInstance",
    tags={
        "mytag": "myval",
    })

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",
        },
        collationName: "SQL_Latin1_General_CP1_CI_AS",
        compatibilityLevel: 150,
        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,
        sizeMB: 150,
        spaceAvailableMB: 100,
        state: azure_native.azurearcdata.DatabaseState.Online,
    },
    resourceGroupName: "testrg",
    sqlServerInstanceName: "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
        collationName: SQL_Latin1_General_CP1_CI_AS
        compatibilityLevel: 150
        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
        sizeMB: 150
        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.

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",
        },
        CollationName = "string",
        CompatibilityLevel = 0,
        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",
        SizeMB = 0,
        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"),
},
CollationName: pulumi.String("string"),
CompatibilityLevel: pulumi.Int(0),
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"),
SizeMB: pulumi.Float64(0),
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())
        .collationName("string")
        .compatibilityLevel(0)
        .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")
        .sizeMB(0)
        .spaceAvailableMB(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=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesArgs(
        backup_information=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesBackupInformationArgs(
            last_full_backup="string",
            last_log_backup="string",
        ),
        collation_name="string",
        compatibility_level=0,
        database_creation_date="string",
        database_options=azure_native.azurearcdata.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs(
            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",
        size_mb=0,
        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",
        },
        collationName: "string",
        compatibilityLevel: 0,
        databaseCreationDate: "string",
        databaseOptions: {
            isAutoCloseOn: false,
            isAutoCreateStatsOn: false,
            isAutoShrinkOn: false,
            isAutoUpdateStatsOn: false,
            isEncrypted: false,
            isMemoryOptimizationEnabled: false,
            isRemoteDataArchiveEnabled: false,
            isTrustworthyOn: false,
        },
        isReadOnly: false,
        recoveryMode: "string",
        sizeMB: 0,
        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
        collationName: string
        compatibilityLevel: 0
        databaseCreationDate: string
        databaseOptions:
            isAutoCloseOn: false
            isAutoCreateStatsOn: false
            isAutoShrinkOn: false
            isAutoUpdateStatsOn: false
            isEncrypted: false
            isMemoryOptimizationEnabled: false
            isRemoteDataArchiveEnabled: false
            isTrustworthyOn: false
        isReadOnly: false
        recoveryMode: string
        sizeMB: 0
        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

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:

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"

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"

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"

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"

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"

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

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
CollationName string: Collation of the database.
CompatibilityLevel int: Compatibility level of the database
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.
SizeMB double: Size of the database.
SpaceAvailableMB double: Space left of the database.
State string | Pulumi.AzureNative.AzureArcData.DatabaseState: State of the database.

BackupInformation SqlServerDatabaseResourcePropertiesBackupInformation
CollationName string: Collation of the database.
CompatibilityLevel int: Compatibility level of the database
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.
SizeMB float64: Size of the database.
SpaceAvailableMB float64: Space left of the database.
State string | DatabaseState: State of the database.

backupInformation SqlServerDatabaseResourcePropertiesBackupInformation
collationName String: Collation of the database.
compatibilityLevel Integer: Compatibility level of the database
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.
sizeMB Double: Size of the database.
spaceAvailableMB Double: Space left of the database.
state String | DatabaseState: State of the database.

backupInformation SqlServerDatabaseResourcePropertiesBackupInformation
collationName string: Collation of the database.
compatibilityLevel number: Compatibility level of the database
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.
sizeMB number: Size of the database.
spaceAvailableMB number: Space left of the database.
state string | DatabaseState: State of the database.

backup_information SqlServerDatabaseResourcePropertiesBackupInformation
collation_name str: Collation of the database.
compatibility_level int: Compatibility level of the database
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.
size_mb float: Size of the database.
space_available_mb float: Space left of the database.
state str | DatabaseState: State of the database.

backupInformation Property Map
collationName String: Collation of the database.
compatibilityLevel Number: Compatibility level of the database
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.
sizeMB Number: Size of the 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

IsAutoCloseOn bool
IsAutoCreateStatsOn bool
IsAutoShrinkOn bool
IsAutoUpdateStatsOn bool
IsEncrypted bool
IsMemoryOptimizationEnabled bool
IsRemoteDataArchiveEnabled bool
IsTrustworthyOn bool

IsAutoCloseOn bool
IsAutoCreateStatsOn bool
IsAutoShrinkOn bool
IsAutoUpdateStatsOn bool
IsEncrypted bool
IsMemoryOptimizationEnabled bool
IsRemoteDataArchiveEnabled bool
IsTrustworthyOn bool

isAutoCloseOn Boolean
isAutoCreateStatsOn Boolean
isAutoShrinkOn Boolean
isAutoUpdateStatsOn Boolean
isEncrypted Boolean
isMemoryOptimizationEnabled Boolean
isRemoteDataArchiveEnabled Boolean
isTrustworthyOn Boolean

isAutoCloseOn boolean
isAutoCreateStatsOn boolean
isAutoShrinkOn boolean
isAutoUpdateStatsOn boolean
isEncrypted boolean
isMemoryOptimizationEnabled boolean
isRemoteDataArchiveEnabled boolean
isTrustworthyOn boolean

is_auto_close_on bool
is_auto_create_stats_on bool
is_auto_shrink_on bool
is_auto_update_stats_on bool
is_encrypted bool
is_memory_optimization_enabled bool
is_remote_data_archive_enabled bool
is_trustworthy_on bool

isAutoCloseOn Boolean
isAutoCreateStatsOn Boolean
isAutoShrinkOn Boolean
isAutoUpdateStatsOn Boolean
isEncrypted Boolean
isMemoryOptimizationEnabled Boolean
isRemoteDataArchiveEnabled Boolean
isTrustworthyOn Boolean

SqlServerDatabaseResourcePropertiesResponse, SqlServerDatabaseResourcePropertiesResponseArgs

ProvisioningState string: The provisioning state of the Arc-enabled SQL Server database resource.
BackupInformation Pulumi.AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesResponseBackupInformation
CollationName string: Collation of the database.
CompatibilityLevel int: Compatibility level of the database
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.
SizeMB double: Size of the database.
SpaceAvailableMB double: Space left of the database.
State string: State of the database.

ProvisioningState string: The provisioning state of the Arc-enabled SQL Server database resource.
BackupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
CollationName string: Collation of the database.
CompatibilityLevel int: Compatibility level of the database
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.
SizeMB float64: Size of the database.
SpaceAvailableMB float64: Space left of the database.
State string: State of the database.

provisioningState String: The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
collationName String: Collation of the database.
compatibilityLevel Integer: Compatibility level of the database
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.
sizeMB Double: Size of the database.
spaceAvailableMB Double: Space left of the database.
state String: State of the database.

provisioningState string: The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation SqlServerDatabaseResourcePropertiesResponseBackupInformation
collationName string: Collation of the database.
compatibilityLevel number: Compatibility level of the database
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.
sizeMB number: Size of the database.
spaceAvailableMB number: Space left of the database.
state string: State of the database.

provisioning_state str: The provisioning state of the Arc-enabled SQL Server database resource.
backup_information SqlServerDatabaseResourcePropertiesResponseBackupInformation
collation_name str: Collation of the database.
compatibility_level int: Compatibility level of the database
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.
size_mb float: Size of the database.
space_available_mb float: Space left of the database.
state str: State of the database.

provisioningState String: The provisioning state of the Arc-enabled SQL Server database resource.
backupInformation Property Map
collationName String: Collation of the database.
compatibilityLevel Number: Compatibility level of the database
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.
sizeMB Number: Size of the 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

IsAutoCloseOn bool
IsAutoCreateStatsOn bool
IsAutoShrinkOn bool
IsAutoUpdateStatsOn bool
IsEncrypted bool
IsMemoryOptimizationEnabled bool
IsRemoteDataArchiveEnabled bool
IsTrustworthyOn bool

IsAutoCloseOn bool
IsAutoCreateStatsOn bool
IsAutoShrinkOn bool
IsAutoUpdateStatsOn bool
IsEncrypted bool
IsMemoryOptimizationEnabled bool
IsRemoteDataArchiveEnabled bool
IsTrustworthyOn bool

isAutoCloseOn Boolean
isAutoCreateStatsOn Boolean
isAutoShrinkOn Boolean
isAutoUpdateStatsOn Boolean
isEncrypted Boolean
isMemoryOptimizationEnabled Boolean
isRemoteDataArchiveEnabled Boolean
isTrustworthyOn Boolean

isAutoCloseOn boolean
isAutoCreateStatsOn boolean
isAutoShrinkOn boolean
isAutoUpdateStatsOn boolean
isEncrypted boolean
isMemoryOptimizationEnabled boolean
isRemoteDataArchiveEnabled boolean
isTrustworthyOn boolean

is_auto_close_on bool
is_auto_create_stats_on bool
is_auto_shrink_on bool
is_auto_update_stats_on bool
is_encrypted bool
is_memory_optimization_enabled bool
is_remote_data_archive_enabled bool
is_trustworthy_on bool

isAutoCloseOn Boolean
isAutoCreateStatsOn Boolean
isAutoShrinkOn Boolean
isAutoUpdateStatsOn Boolean
isEncrypted Boolean
isMemoryOptimizationEnabled Boolean
isRemoteDataArchiveEnabled Boolean
isTrustworthyOn Boolean

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

This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.

Azure Native v2.39.0 published on Monday, Apr 29, 2024 by Pulumi

pulumi/pulumi-azure-native

azure-native.azurearcdata.SqlServerDatabase

On this page

On this page

Example Usage

Create a Arc Sql Server database.

Create SqlServerDatabase Resource

Constructor syntax

Parameters

Example

SqlServerDatabase Resource Properties

Inputs

Outputs

Supporting Types

DatabaseState, DatabaseStateArgs

RecoveryMode, RecoveryModeArgs

SqlServerDatabaseResourceProperties, SqlServerDatabaseResourcePropertiesArgs

SqlServerDatabaseResourcePropertiesBackupInformation, SqlServerDatabaseResourcePropertiesBackupInformationArgs

SqlServerDatabaseResourcePropertiesDatabaseOptions, SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs

SqlServerDatabaseResourcePropertiesResponse, SqlServerDatabaseResourcePropertiesResponseArgs

SqlServerDatabaseResourcePropertiesResponseBackupInformation, SqlServerDatabaseResourcePropertiesResponseBackupInformationArgs

SqlServerDatabaseResourcePropertiesResponseDatabaseOptions, SqlServerDatabaseResourcePropertiesResponseDatabaseOptionsArgs

SystemDataResponse, SystemDataResponseArgs

Import

Package Details

On this page

On this page