ManagedDatabase Class

A managed database resource.

Variables are only populated by the server, and will be ignored when sending a request.

All required parameters must be populated in order to send to Azure.

Inheritance

azure.mgmt.sql.models._models_py3.TrackedResource

ManagedDatabase

Constructor

ManagedDatabase(*, location: str, tags: Dict[str, str] | None = None, collation: str | None = None, restore_point_in_time: datetime | None = None, catalog_collation: str | CatalogCollationType | None = None, create_mode: str | ManagedDatabaseCreateMode | None = None, storage_container_uri: str | None = None, source_database_id: str | None = None, restorable_dropped_database_id: str | None = None, storage_container_sas_token: str | None = None, recoverable_database_id: str | None = None, long_term_retention_backup_resource_id: str | None = None, auto_complete_restore: bool | None = None, last_backup_name: str | None = None, **kwargs)

Parameters

Name	Description
location Required	str Required. Resource location.
tags Required	dict[str, str] A set of tags. Resource tags.
collation Required	str Collation of the managed database.
restore_point_in_time Required	datetime 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.
catalog_collation Required	str or CatalogCollationType Collation of the metadata catalog. Possible values include: "DATABASE_DEFAULT", "SQL_Latin1_General_CP1_CI_AS".
create_mode Required	str or 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). Possible values include: "Default", "RestoreExternalBackup", "PointInTimeRestore", "Recovery", "RestoreLongTermRetentionBackup".
storage_container_uri Required	str Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
source_database_id Required	str The resource identifier of the source database associated with create operation of this database.
restorable_dropped_database_id Required	str The restorable dropped database resource id to restore when creating this database.
storage_container_sas_token Required	str Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
recoverable_database_id Required	str The resource identifier of the recoverable database associated with create operation of this database.
long_term_retention_backup_resource_id Required	str The name of the Long Term Retention backup to be used for restore of this managed database.
auto_complete_restore Required	bool Whether to auto complete restore of this managed database.
last_backup_name Required	str Last backup file name for restore of this managed database.

Keyword-Only Parameters

Name	Description
location Required
tags Required
collation Required
restore_point_in_time Required
catalog_collation Required
create_mode Required
storage_container_uri Required
source_database_id Required
restorable_dropped_database_id Required
storage_container_sas_token Required
recoverable_database_id Required
long_term_retention_backup_resource_id Required
auto_complete_restore Required
last_backup_name Required

Variables

Name	Description
id	str Resource ID.
name	str Resource name.
type	str Resource type.
status	str or ManagedDatabaseStatus Status of the database. Possible values include: "Online", "Offline", "Shutdown", "Creating", "Inaccessible", "Restoring", "Updating".
creation_date	datetime Creation date of the database.
earliest_restore_point	datetime Earliest restore point in time for point in time restore.
default_secondary_location	str Geo paired region.
failover_group_id	str Instance Failover Group resource identifier that this managed database belongs to.