1. Packages
  2. Azure Native
  3. API Docs
  4. sql
  5. ManagedDatabase
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.38.0 published on Monday, Apr 22, 2024 by Pulumi

azure-native.sql.ManagedDatabase

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.38.0 published on Monday, Apr 22, 2024 by Pulumi

    A managed database resource. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview.

    Other available API versions: 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview.

    Example Usage

    Creates a new managed database by restoring from an external backup

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            AutoCompleteRestore = true,
            Collation = "SQL_Latin1_General_CP1_CI_AS",
            CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
            DatabaseName = "managedDatabase",
            LastBackupName = "last_backup_name",
            Location = "southeastasia",
            ManagedInstanceName = "managedInstance",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
            StorageContainerSasToken = "sv=2015-12-11&sr=c&sp=rl&sig=1234",
            StorageContainerUri = "https://myaccountname.blob.core.windows.net/backups",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			AutoCompleteRestore:      pulumi.Bool(true),
    			Collation:                pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
    			CreateMode:               pulumi.String(sql.ManagedDatabaseCreateModeRestoreExternalBackup),
    			DatabaseName:             pulumi.String("managedDatabase"),
    			LastBackupName:           pulumi.String("last_backup_name"),
    			Location:                 pulumi.String("southeastasia"),
    			ManagedInstanceName:      pulumi.String("managedInstance"),
    			ResourceGroupName:        pulumi.String("Default-SQL-SouthEastAsia"),
    			StorageContainerSasToken: pulumi.String("sv=2015-12-11&sr=c&sp=rl&sig=1234"),
    			StorageContainerUri:      pulumi.String("https://myaccountname.blob.core.windows.net/backups"),
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .autoCompleteRestore(true)
                .collation("SQL_Latin1_General_CP1_CI_AS")
                .createMode("RestoreExternalBackup")
                .databaseName("managedDatabase")
                .lastBackupName("last_backup_name")
                .location("southeastasia")
                .managedInstanceName("managedInstance")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .storageContainerSasToken("sv=2015-12-11&sr=c&sp=rl&sig=1234")
                .storageContainerUri("https://myaccountname.blob.core.windows.net/backups")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        auto_complete_restore=True,
        collation="SQL_Latin1_General_CP1_CI_AS",
        create_mode=azure_native.sql.ManagedDatabaseCreateMode.RESTORE_EXTERNAL_BACKUP,
        database_name="managedDatabase",
        last_backup_name="last_backup_name",
        location="southeastasia",
        managed_instance_name="managedInstance",
        resource_group_name="Default-SQL-SouthEastAsia",
        storage_container_sas_token="sv=2015-12-11&sr=c&sp=rl&sig=1234",
        storage_container_uri="https://myaccountname.blob.core.windows.net/backups")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        autoCompleteRestore: true,
        collation: "SQL_Latin1_General_CP1_CI_AS",
        createMode: azure_native.sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
        databaseName: "managedDatabase",
        lastBackupName: "last_backup_name",
        location: "southeastasia",
        managedInstanceName: "managedInstance",
        resourceGroupName: "Default-SQL-SouthEastAsia",
        storageContainerSasToken: "sv=2015-12-11&sr=c&sp=rl&sig=1234",
        storageContainerUri: "https://myaccountname.blob.core.windows.net/backups",
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          autoCompleteRestore: true
          collation: SQL_Latin1_General_CP1_CI_AS
          createMode: RestoreExternalBackup
          databaseName: managedDatabase
          lastBackupName: last_backup_name
          location: southeastasia
          managedInstanceName: managedInstance
          resourceGroupName: Default-SQL-SouthEastAsia
          storageContainerSasToken: sv=2015-12-11&sr=c&sp=rl&sig=1234
          storageContainerUri: https://myaccountname.blob.core.windows.net/backups
    

    Creates a new managed database from restoring a geo-replicated backup

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.Recovery,
            DatabaseName = "testdb_recovered",
            Location = "southeastasia",
            ManagedInstanceName = "server1",
            RecoverableDatabaseId = "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			CreateMode:            pulumi.String(sql.ManagedDatabaseCreateModeRecovery),
    			DatabaseName:          pulumi.String("testdb_recovered"),
    			Location:              pulumi.String("southeastasia"),
    			ManagedInstanceName:   pulumi.String("server1"),
    			RecoverableDatabaseId: pulumi.String("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb"),
    			ResourceGroupName:     pulumi.String("Default-SQL-SouthEastAsia"),
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .createMode("Recovery")
                .databaseName("testdb_recovered")
                .location("southeastasia")
                .managedInstanceName("server1")
                .recoverableDatabaseId("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        create_mode=azure_native.sql.ManagedDatabaseCreateMode.RECOVERY,
        database_name="testdb_recovered",
        location="southeastasia",
        managed_instance_name="server1",
        recoverable_database_id="/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
        resource_group_name="Default-SQL-SouthEastAsia")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        createMode: azure_native.sql.ManagedDatabaseCreateMode.Recovery,
        databaseName: "testdb_recovered",
        location: "southeastasia",
        managedInstanceName: "server1",
        recoverableDatabaseId: "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
        resourceGroupName: "Default-SQL-SouthEastAsia",
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          createMode: Recovery
          databaseName: testdb_recovered
          location: southeastasia
          managedInstanceName: server1
          recoverableDatabaseId: /subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb
          resourceGroupName: Default-SQL-SouthEastAsia
    

    Creates a new managed database from restoring a long term retention backup

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            Collation = "SQL_Latin1_General_CP1_CI_AS",
            CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
            DatabaseName = "managedDatabase",
            Location = "southeastasia",
            ManagedInstanceName = "managedInstance",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
            StorageContainerSasToken = "sv=2015-12-11&sr=c&sp=rl&sig=1234",
            StorageContainerUri = "https://myaccountname.blob.core.windows.net/backups",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			Collation:                pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
    			CreateMode:               pulumi.String(sql.ManagedDatabaseCreateModeRestoreExternalBackup),
    			DatabaseName:             pulumi.String("managedDatabase"),
    			Location:                 pulumi.String("southeastasia"),
    			ManagedInstanceName:      pulumi.String("managedInstance"),
    			ResourceGroupName:        pulumi.String("Default-SQL-SouthEastAsia"),
    			StorageContainerSasToken: pulumi.String("sv=2015-12-11&sr=c&sp=rl&sig=1234"),
    			StorageContainerUri:      pulumi.String("https://myaccountname.blob.core.windows.net/backups"),
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .collation("SQL_Latin1_General_CP1_CI_AS")
                .createMode("RestoreExternalBackup")
                .databaseName("managedDatabase")
                .location("southeastasia")
                .managedInstanceName("managedInstance")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .storageContainerSasToken("sv=2015-12-11&sr=c&sp=rl&sig=1234")
                .storageContainerUri("https://myaccountname.blob.core.windows.net/backups")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        collation="SQL_Latin1_General_CP1_CI_AS",
        create_mode=azure_native.sql.ManagedDatabaseCreateMode.RESTORE_EXTERNAL_BACKUP,
        database_name="managedDatabase",
        location="southeastasia",
        managed_instance_name="managedInstance",
        resource_group_name="Default-SQL-SouthEastAsia",
        storage_container_sas_token="sv=2015-12-11&sr=c&sp=rl&sig=1234",
        storage_container_uri="https://myaccountname.blob.core.windows.net/backups")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        collation: "SQL_Latin1_General_CP1_CI_AS",
        createMode: azure_native.sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
        databaseName: "managedDatabase",
        location: "southeastasia",
        managedInstanceName: "managedInstance",
        resourceGroupName: "Default-SQL-SouthEastAsia",
        storageContainerSasToken: "sv=2015-12-11&sr=c&sp=rl&sig=1234",
        storageContainerUri: "https://myaccountname.blob.core.windows.net/backups",
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          collation: SQL_Latin1_General_CP1_CI_AS
          createMode: RestoreExternalBackup
          databaseName: managedDatabase
          location: southeastasia
          managedInstanceName: managedInstance
          resourceGroupName: Default-SQL-SouthEastAsia
          storageContainerSasToken: sv=2015-12-11&sr=c&sp=rl&sig=1234
          storageContainerUri: https://myaccountname.blob.core.windows.net/backups
    

    Creates a new managed database using point in time restore

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.PointInTimeRestore,
            DatabaseName = "managedDatabase",
            Location = "southeastasia",
            ManagedInstanceName = "managedInstance",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
            RestorePointInTime = "2017-07-14T05:35:31.503Z",
            SourceDatabaseId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			CreateMode:          pulumi.String(sql.ManagedDatabaseCreateModePointInTimeRestore),
    			DatabaseName:        pulumi.String("managedDatabase"),
    			Location:            pulumi.String("southeastasia"),
    			ManagedInstanceName: pulumi.String("managedInstance"),
    			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
    			RestorePointInTime:  pulumi.String("2017-07-14T05:35:31.503Z"),
    			SourceDatabaseId:    pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb"),
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .createMode("PointInTimeRestore")
                .databaseName("managedDatabase")
                .location("southeastasia")
                .managedInstanceName("managedInstance")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .restorePointInTime("2017-07-14T05:35:31.503Z")
                .sourceDatabaseId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        create_mode=azure_native.sql.ManagedDatabaseCreateMode.POINT_IN_TIME_RESTORE,
        database_name="managedDatabase",
        location="southeastasia",
        managed_instance_name="managedInstance",
        resource_group_name="Default-SQL-SouthEastAsia",
        restore_point_in_time="2017-07-14T05:35:31.503Z",
        source_database_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        createMode: azure_native.sql.ManagedDatabaseCreateMode.PointInTimeRestore,
        databaseName: "managedDatabase",
        location: "southeastasia",
        managedInstanceName: "managedInstance",
        resourceGroupName: "Default-SQL-SouthEastAsia",
        restorePointInTime: "2017-07-14T05:35:31.503Z",
        sourceDatabaseId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb",
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          createMode: PointInTimeRestore
          databaseName: managedDatabase
          location: southeastasia
          managedInstanceName: managedInstance
          resourceGroupName: Default-SQL-SouthEastAsia
          restorePointInTime: 2017-07-14T05:35:31.503Z
          sourceDatabaseId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb
    

    Creates a new managed database with maximal properties

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            DatabaseName = "managedDatabase",
            Location = "southeastasia",
            ManagedInstanceName = "managedInstance",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
            Tags = 
            {
                { "tagKey1", "TagValue1" },
            },
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			DatabaseName:        pulumi.String("managedDatabase"),
    			Location:            pulumi.String("southeastasia"),
    			ManagedInstanceName: pulumi.String("managedInstance"),
    			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
    			Tags: pulumi.StringMap{
    				"tagKey1": pulumi.String("TagValue1"),
    			},
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .databaseName("managedDatabase")
                .location("southeastasia")
                .managedInstanceName("managedInstance")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .tags(Map.of("tagKey1", "TagValue1"))
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        database_name="managedDatabase",
        location="southeastasia",
        managed_instance_name="managedInstance",
        resource_group_name="Default-SQL-SouthEastAsia",
        tags={
            "tagKey1": "TagValue1",
        })
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        databaseName: "managedDatabase",
        location: "southeastasia",
        managedInstanceName: "managedInstance",
        resourceGroupName: "Default-SQL-SouthEastAsia",
        tags: {
            tagKey1: "TagValue1",
        },
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          databaseName: managedDatabase
          location: southeastasia
          managedInstanceName: managedInstance
          resourceGroupName: Default-SQL-SouthEastAsia
          tags:
            tagKey1: TagValue1
    

    Creates a new managed database with minimal properties

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
        {
            DatabaseName = "managedDatabase",
            Location = "southeastasia",
            ManagedInstanceName = "managedInstance",
            ResourceGroupName = "Default-SQL-SouthEastAsia",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
    			DatabaseName:        pulumi.String("managedDatabase"),
    			Location:            pulumi.String("southeastasia"),
    			ManagedInstanceName: pulumi.String("managedInstance"),
    			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
    		})
    		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.sql.ManagedDatabase;
    import com.pulumi.azurenative.sql.ManagedDatabaseArgs;
    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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()        
                .databaseName("managedDatabase")
                .location("southeastasia")
                .managedInstanceName("managedInstance")
                .resourceGroupName("Default-SQL-SouthEastAsia")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
        database_name="managedDatabase",
        location="southeastasia",
        managed_instance_name="managedInstance",
        resource_group_name="Default-SQL-SouthEastAsia")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
        databaseName: "managedDatabase",
        location: "southeastasia",
        managedInstanceName: "managedInstance",
        resourceGroupName: "Default-SQL-SouthEastAsia",
    });
    
    resources:
      managedDatabase:
        type: azure-native:sql:ManagedDatabase
        properties:
          databaseName: managedDatabase
          location: southeastasia
          managedInstanceName: managedInstance
          resourceGroupName: Default-SQL-SouthEastAsia
    

    Create ManagedDatabase Resource

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

    Constructor syntax

    new ManagedDatabase(name: string, args: ManagedDatabaseArgs, opts?: CustomResourceOptions);
    @overload
    def ManagedDatabase(resource_name: str,
                        args: ManagedDatabaseArgs,
                        opts: Optional[ResourceOptions] = None)
    
    @overload
    def ManagedDatabase(resource_name: str,
                        opts: Optional[ResourceOptions] = None,
                        managed_instance_name: Optional[str] = None,
                        resource_group_name: Optional[str] = None,
                        database_name: Optional[str] = None,
                        recoverable_database_id: Optional[str] = None,
                        auto_complete_restore: Optional[bool] = None,
                        last_backup_name: Optional[str] = None,
                        location: Optional[str] = None,
                        long_term_retention_backup_resource_id: Optional[str] = None,
                        collation: Optional[str] = None,
                        create_mode: Optional[Union[str, ManagedDatabaseCreateMode]] = None,
                        catalog_collation: Optional[Union[str, CatalogCollationType]] = None,
                        restorable_dropped_database_id: Optional[str] = None,
                        restore_point_in_time: Optional[str] = None,
                        source_database_id: Optional[str] = None,
                        storage_container_sas_token: Optional[str] = None,
                        storage_container_uri: Optional[str] = None,
                        tags: Optional[Mapping[str, str]] = None)
    func NewManagedDatabase(ctx *Context, name string, args ManagedDatabaseArgs, opts ...ResourceOption) (*ManagedDatabase, error)
    public ManagedDatabase(string name, ManagedDatabaseArgs args, CustomResourceOptions? opts = null)
    public ManagedDatabase(String name, ManagedDatabaseArgs args)
    public ManagedDatabase(String name, ManagedDatabaseArgs args, CustomResourceOptions options)
    
    type: azure-native:sql:ManagedDatabase
    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 ManagedDatabaseArgs
    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 ManagedDatabaseArgs
    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 ManagedDatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedDatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedDatabaseArgs
    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 managedDatabaseResource = new AzureNative.Sql.ManagedDatabase("managedDatabaseResource", new()
    {
        ManagedInstanceName = "string",
        ResourceGroupName = "string",
        DatabaseName = "string",
        RecoverableDatabaseId = "string",
        AutoCompleteRestore = false,
        LastBackupName = "string",
        Location = "string",
        LongTermRetentionBackupResourceId = "string",
        Collation = "string",
        CreateMode = "string",
        CatalogCollation = "string",
        RestorableDroppedDatabaseId = "string",
        RestorePointInTime = "string",
        SourceDatabaseId = "string",
        StorageContainerSasToken = "string",
        StorageContainerUri = "string",
        Tags = 
        {
            { "string", "string" },
        },
    });
    
    example, err := sql.NewManagedDatabase(ctx, "managedDatabaseResource", &sql.ManagedDatabaseArgs{
    ManagedInstanceName: pulumi.String("string"),
    ResourceGroupName: pulumi.String("string"),
    DatabaseName: pulumi.String("string"),
    RecoverableDatabaseId: pulumi.String("string"),
    AutoCompleteRestore: pulumi.Bool(false),
    LastBackupName: pulumi.String("string"),
    Location: pulumi.String("string"),
    LongTermRetentionBackupResourceId: pulumi.String("string"),
    Collation: pulumi.String("string"),
    CreateMode: pulumi.String("string"),
    CatalogCollation: pulumi.String("string"),
    RestorableDroppedDatabaseId: pulumi.String("string"),
    RestorePointInTime: pulumi.String("string"),
    SourceDatabaseId: pulumi.String("string"),
    StorageContainerSasToken: pulumi.String("string"),
    StorageContainerUri: pulumi.String("string"),
    Tags: pulumi.StringMap{
    "string": pulumi.String("string"),
    },
    })
    
    var managedDatabaseResource = new ManagedDatabase("managedDatabaseResource", ManagedDatabaseArgs.builder()        
        .managedInstanceName("string")
        .resourceGroupName("string")
        .databaseName("string")
        .recoverableDatabaseId("string")
        .autoCompleteRestore(false)
        .lastBackupName("string")
        .location("string")
        .longTermRetentionBackupResourceId("string")
        .collation("string")
        .createMode("string")
        .catalogCollation("string")
        .restorableDroppedDatabaseId("string")
        .restorePointInTime("string")
        .sourceDatabaseId("string")
        .storageContainerSasToken("string")
        .storageContainerUri("string")
        .tags(Map.of("string", "string"))
        .build());
    
    managed_database_resource = azure_native.sql.ManagedDatabase("managedDatabaseResource",
        managed_instance_name="string",
        resource_group_name="string",
        database_name="string",
        recoverable_database_id="string",
        auto_complete_restore=False,
        last_backup_name="string",
        location="string",
        long_term_retention_backup_resource_id="string",
        collation="string",
        create_mode="string",
        catalog_collation="string",
        restorable_dropped_database_id="string",
        restore_point_in_time="string",
        source_database_id="string",
        storage_container_sas_token="string",
        storage_container_uri="string",
        tags={
            "string": "string",
        })
    
    const managedDatabaseResource = new azure_native.sql.ManagedDatabase("managedDatabaseResource", {
        managedInstanceName: "string",
        resourceGroupName: "string",
        databaseName: "string",
        recoverableDatabaseId: "string",
        autoCompleteRestore: false,
        lastBackupName: "string",
        location: "string",
        longTermRetentionBackupResourceId: "string",
        collation: "string",
        createMode: "string",
        catalogCollation: "string",
        restorableDroppedDatabaseId: "string",
        restorePointInTime: "string",
        sourceDatabaseId: "string",
        storageContainerSasToken: "string",
        storageContainerUri: "string",
        tags: {
            string: "string",
        },
    });
    
    type: azure-native:sql:ManagedDatabase
    properties:
        autoCompleteRestore: false
        catalogCollation: string
        collation: string
        createMode: string
        databaseName: string
        lastBackupName: string
        location: string
        longTermRetentionBackupResourceId: string
        managedInstanceName: string
        recoverableDatabaseId: string
        resourceGroupName: string
        restorableDroppedDatabaseId: string
        restorePointInTime: string
        sourceDatabaseId: string
        storageContainerSasToken: string
        storageContainerUri: string
        tags:
            string: string
    

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

    ManagedInstanceName string
    The name of the managed instance.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AutoCompleteRestore bool
    Whether to auto complete restore of this managed database.
    CatalogCollation string | Pulumi.AzureNative.Sql.CatalogCollationType
    Collation of the metadata catalog.
    Collation string
    Collation of the managed database.
    CreateMode string | Pulumi.AzureNative.Sql.ManagedDatabaseCreateMode
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    DatabaseName string
    The name of the database.
    LastBackupName string
    Last backup file name for restore of this managed database.
    Location string
    Resource location.
    LongTermRetentionBackupResourceId string
    The name of the Long Term Retention backup to be used for restore of this managed database.
    RecoverableDatabaseId string
    The resource identifier of the recoverable database associated with create operation of this database.
    RestorableDroppedDatabaseId string
    The restorable dropped database resource id to restore when creating this 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.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    StorageContainerSasToken string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    StorageContainerUri string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    Tags Dictionary<string, string>
    Resource tags.
    ManagedInstanceName string
    The name of the managed instance.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AutoCompleteRestore bool
    Whether to auto complete restore of this managed database.
    CatalogCollation string | CatalogCollationType
    Collation of the metadata catalog.
    Collation string
    Collation of the managed database.
    CreateMode string | ManagedDatabaseCreateMode
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    DatabaseName string
    The name of the database.
    LastBackupName string
    Last backup file name for restore of this managed database.
    Location string
    Resource location.
    LongTermRetentionBackupResourceId string
    The name of the Long Term Retention backup to be used for restore of this managed database.
    RecoverableDatabaseId string
    The resource identifier of the recoverable database associated with create operation of this database.
    RestorableDroppedDatabaseId string
    The restorable dropped database resource id to restore when creating this 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.
    SourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    StorageContainerSasToken string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    StorageContainerUri string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    Tags map[string]string
    Resource tags.
    managedInstanceName String
    The name of the managed instance.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    autoCompleteRestore Boolean
    Whether to auto complete restore of this managed database.
    catalogCollation String | CatalogCollationType
    Collation of the metadata catalog.
    collation String
    Collation of the managed database.
    createMode String | ManagedDatabaseCreateMode
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    databaseName String
    The name of the database.
    lastBackupName String
    Last backup file name for restore of this managed database.
    location String
    Resource location.
    longTermRetentionBackupResourceId String
    The name of the Long Term Retention backup to be used for restore of this managed database.
    recoverableDatabaseId String
    The resource identifier of the recoverable database associated with create operation of this database.
    restorableDroppedDatabaseId String
    The restorable dropped database resource id to restore when creating this 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.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    storageContainerSasToken String
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    storageContainerUri String
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    tags Map<String,String>
    Resource tags.
    managedInstanceName string
    The name of the managed instance.
    resourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    autoCompleteRestore boolean
    Whether to auto complete restore of this managed database.
    catalogCollation string | CatalogCollationType
    Collation of the metadata catalog.
    collation string
    Collation of the managed database.
    createMode string | ManagedDatabaseCreateMode
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    databaseName string
    The name of the database.
    lastBackupName string
    Last backup file name for restore of this managed database.
    location string
    Resource location.
    longTermRetentionBackupResourceId string
    The name of the Long Term Retention backup to be used for restore of this managed database.
    recoverableDatabaseId string
    The resource identifier of the recoverable database associated with create operation of this database.
    restorableDroppedDatabaseId string
    The restorable dropped database resource id to restore when creating this 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.
    sourceDatabaseId string
    The resource identifier of the source database associated with create operation of this database.
    storageContainerSasToken string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    storageContainerUri string
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    tags {[key: string]: string}
    Resource tags.
    managed_instance_name str
    The name of the managed instance.
    resource_group_name str
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    auto_complete_restore bool
    Whether to auto complete restore of this managed database.
    catalog_collation str | CatalogCollationType
    Collation of the metadata catalog.
    collation str
    Collation of the managed database.
    create_mode str | ManagedDatabaseCreateMode
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    database_name str
    The name of the database.
    last_backup_name str
    Last backup file name for restore of this managed database.
    location str
    Resource location.
    long_term_retention_backup_resource_id str
    The name of the Long Term Retention backup to be used for restore of this managed database.
    recoverable_database_id str
    The resource identifier of the recoverable database associated with create operation of this database.
    restorable_dropped_database_id str
    The restorable dropped database resource id to restore when creating this 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.
    source_database_id str
    The resource identifier of the source database associated with create operation of this database.
    storage_container_sas_token str
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    storage_container_uri str
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    tags Mapping[str, str]
    Resource tags.
    managedInstanceName String
    The name of the managed instance.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    autoCompleteRestore Boolean
    Whether to auto complete restore of this managed database.
    catalogCollation String | "DATABASE_DEFAULT" | "SQL_Latin1_General_CP1_CI_AS"
    Collation of the metadata catalog.
    collation String
    Collation of the managed database.
    createMode String | "Default" | "RestoreExternalBackup" | "PointInTimeRestore" | "Recovery" | "RestoreLongTermRetentionBackup"
    Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
    databaseName String
    The name of the database.
    lastBackupName String
    Last backup file name for restore of this managed database.
    location String
    Resource location.
    longTermRetentionBackupResourceId String
    The name of the Long Term Retention backup to be used for restore of this managed database.
    recoverableDatabaseId String
    The resource identifier of the recoverable database associated with create operation of this database.
    restorableDroppedDatabaseId String
    The restorable dropped database resource id to restore when creating this 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.
    sourceDatabaseId String
    The resource identifier of the source database associated with create operation of this database.
    storageContainerSasToken String
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
    storageContainerUri String
    Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
    tags Map<String>
    Resource tags.

    Outputs

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

    CreationDate string
    Creation date of the database.
    DefaultSecondaryLocation string
    Geo paired region.
    EarliestRestorePoint string
    Earliest restore point in time for point in time restore.
    FailoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Resource name.
    Status string
    Status of the database.
    Type string
    Resource type.
    CreationDate string
    Creation date of the database.
    DefaultSecondaryLocation string
    Geo paired region.
    EarliestRestorePoint string
    Earliest restore point in time for point in time restore.
    FailoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Resource name.
    Status string
    Status of the database.
    Type string
    Resource type.
    creationDate String
    Creation date of the database.
    defaultSecondaryLocation String
    Geo paired region.
    earliestRestorePoint String
    Earliest restore point in time for point in time restore.
    failoverGroupId String
    Instance Failover Group resource identifier that this managed database belongs to.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Resource name.
    status String
    Status of the database.
    type String
    Resource type.
    creationDate string
    Creation date of the database.
    defaultSecondaryLocation string
    Geo paired region.
    earliestRestorePoint string
    Earliest restore point in time for point in time restore.
    failoverGroupId string
    Instance Failover Group resource identifier that this managed database belongs to.
    id string
    The provider-assigned unique ID for this managed resource.
    name string
    Resource name.
    status string
    Status of the database.
    type string
    Resource type.
    creation_date str
    Creation date of the database.
    default_secondary_location str
    Geo paired region.
    earliest_restore_point str
    Earliest restore point in time for point in time restore.
    failover_group_id str
    Instance Failover Group resource identifier that this managed database belongs to.
    id str
    The provider-assigned unique ID for this managed resource.
    name str
    Resource name.
    status str
    Status of the database.
    type str
    Resource type.
    creationDate String
    Creation date of the database.
    defaultSecondaryLocation String
    Geo paired region.
    earliestRestorePoint String
    Earliest restore point in time for point in time restore.
    failoverGroupId String
    Instance Failover Group resource identifier that this managed database belongs to.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Resource name.
    status String
    Status of the database.
    type String
    Resource type.

    Supporting Types

    CatalogCollationType, CatalogCollationTypeArgs

    DATABASE_DEFAULT
    DATABASE_DEFAULT
    SQL_Latin1_General_CP1_CI_AS
    SQL_Latin1_General_CP1_CI_AS
    CatalogCollationType_DATABASE_DEFAULT
    DATABASE_DEFAULT
    CatalogCollationType_SQL_Latin1_General_CP1_CI_AS
    SQL_Latin1_General_CP1_CI_AS
    DATABASE_DEFAULT
    DATABASE_DEFAULT
    SQL_Latin1_General_CP1_CI_AS
    SQL_Latin1_General_CP1_CI_AS
    DATABASE_DEFAULT
    DATABASE_DEFAULT
    SQL_Latin1_General_CP1_CI_AS
    SQL_Latin1_General_CP1_CI_AS
    DATABAS_E_DEFAULT
    DATABASE_DEFAULT
    SQ_L_LATIN1_GENERAL_CP1_C_I_AS
    SQL_Latin1_General_CP1_CI_AS
    "DATABASE_DEFAULT"
    DATABASE_DEFAULT
    "SQL_Latin1_General_CP1_CI_AS"
    SQL_Latin1_General_CP1_CI_AS

    ManagedDatabaseCreateMode, ManagedDatabaseCreateModeArgs

    Default
    Default
    RestoreExternalBackup
    RestoreExternalBackup
    PointInTimeRestore
    PointInTimeRestore
    Recovery
    Recovery
    RestoreLongTermRetentionBackup
    RestoreLongTermRetentionBackup
    ManagedDatabaseCreateModeDefault
    Default
    ManagedDatabaseCreateModeRestoreExternalBackup
    RestoreExternalBackup
    ManagedDatabaseCreateModePointInTimeRestore
    PointInTimeRestore
    ManagedDatabaseCreateModeRecovery
    Recovery
    ManagedDatabaseCreateModeRestoreLongTermRetentionBackup
    RestoreLongTermRetentionBackup
    Default
    Default
    RestoreExternalBackup
    RestoreExternalBackup
    PointInTimeRestore
    PointInTimeRestore
    Recovery
    Recovery
    RestoreLongTermRetentionBackup
    RestoreLongTermRetentionBackup
    Default
    Default
    RestoreExternalBackup
    RestoreExternalBackup
    PointInTimeRestore
    PointInTimeRestore
    Recovery
    Recovery
    RestoreLongTermRetentionBackup
    RestoreLongTermRetentionBackup
    DEFAULT
    Default
    RESTORE_EXTERNAL_BACKUP
    RestoreExternalBackup
    POINT_IN_TIME_RESTORE
    PointInTimeRestore
    RECOVERY
    Recovery
    RESTORE_LONG_TERM_RETENTION_BACKUP
    RestoreLongTermRetentionBackup
    "Default"
    Default
    "RestoreExternalBackup"
    RestoreExternalBackup
    "PointInTimeRestore"
    PointInTimeRestore
    "Recovery"
    Recovery
    "RestoreLongTermRetentionBackup"
    RestoreLongTermRetentionBackup

    Import

    An existing resource can be imported using its type token, name, and identifier, e.g.

    $ pulumi import azure-native:sql:ManagedDatabase testdb1 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/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.38.0 published on Monday, Apr 22, 2024 by Pulumi