1. Packages
  2. Azure Native
  3. API Docs
  4. azurearcdata
  5. SqlServerDatabase
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.49.1 published on Tuesday, Jul 9, 2024 by Pulumi

azure-native.azurearcdata.SqlServerDatabase

Explore with Pulumi AI

azure-native logo
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.49.1 published on Tuesday, Jul 9, 2024 by Pulumi

    Arc Sql Server database Azure REST API version: 2023-01-15-preview.

    Other available API versions: 2024-01-01.

    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 (
    	azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := azurearcdata.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={
            "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,
        },
        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.

    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",
            },
            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={
            "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",
        },
        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

    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

    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 v1 docs if using the v1 version of this package.
    Azure Native v2.49.1 published on Tuesday, Jul 9, 2024 by Pulumi