Class ManagedDatabase

A managed database resource.

Inheritance
Object
Resource
TrackedResource
ManagedDatabase
Inherited Members
Namespace: System.Dynamic.ExpandoObject
Assembly: Microsoft.Azure.Management.Sql.dll
Syntax
[Microsoft.Rest.Serialization.JsonTransformation]
public class ManagedDatabase : Microsoft.Azure.Management.Sql.Models.TrackedResource

Constructors

ManagedDatabase()

Initializes a new instance of the ManagedDatabase class.

Declaration
public ManagedDatabase ();

ManagedDatabase(String, String, String, String, IDictionary<String,String>, String, String, Nullable<DateTime>, Nullable<DateTime>, Nullable<DateTime>, String, String, String, String, String, String, String, String, String)

Initializes a new instance of the ManagedDatabase class.

Declaration
public ManagedDatabase (string location, string id = null, string name = null, string type = null, System.Collections.Generic.IDictionary<string,string> tags = null, string collation = null, string status = null, Nullable<DateTime> creationDate = null, Nullable<DateTime> earliestRestorePoint = null, Nullable<DateTime> restorePointInTime = null, string defaultSecondaryLocation = null, string catalogCollation = null, string createMode = null, string storageContainerUri = null, string sourceDatabaseId = null, string restorableDroppedDatabaseId = null, string storageContainerSasToken = null, string failoverGroupId = null, string recoverableDatabaseId = null);
Parameters
String location

Resource location.
String id

Resource ID.
String name

Resource name.
String type

Resource type.
IDictionary<String,String> tags

Resource tags.
String collation

Collation of the managed database.
String status

Status of the database. Possible values include: 'Online', 'Offline', 'Shutdown', 'Creating', 'Inaccessible', 'Updating'
Nullable<DateTime> creationDate

Creation date of the database.
Nullable<DateTime> earliestRestorePoint

Earliest restore point in time for point in time restore.
Nullable<DateTime> restorePointInTime

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.
String defaultSecondaryLocation

Geo paired region.
String catalogCollation

Collation of the metadata catalog. Possible values include: 'DATABASE_DEFAULT', 'SQL_Latin1_General_CP1_CI_AS'
String createMode

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. Possible values include: 'Default', 'RestoreExternalBackup', 'PointInTimeRestore', 'Recovery'
String storageContainerUri

Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
String sourceDatabaseId

The resource identifier of the source database associated with create operation of this database.
String restorableDroppedDatabaseId

The restorable dropped database resource id to restore when creating this database.
String storageContainerSasToken

Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.
String failoverGroupId

Instance Failover Group resource identifier that this managed database belongs to.
String recoverableDatabaseId

The resource identifier of the recoverable database associated with create operation of this database.

Properties

CatalogCollation

Gets or sets collation of the metadata catalog. Possible values include: 'DATABASE_DEFAULT', 'SQL_Latin1_General_CP1_CI_AS'

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.catalogCollation")]
public string CatalogCollation { get; set; }
Property Value
String

Collation

Gets or sets collation of the managed database.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.collation")]
public string Collation { get; set; }
Property Value
String

CreateMode

Gets or sets 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. Possible values include: 'Default', 'RestoreExternalBackup', 'PointInTimeRestore', 'Recovery'

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.createMode")]
public string CreateMode { get; set; }
Property Value
String

CreationDate

Gets creation date of the database.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.creationDate")]
public Nullable<DateTime> CreationDate { get; }
Property Value
Nullable<DateTime>

DefaultSecondaryLocation

Gets geo paired region.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.defaultSecondaryLocation")]
public string DefaultSecondaryLocation { get; }
Property Value
String

EarliestRestorePoint

Gets earliest restore point in time for point in time restore.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.earliestRestorePoint")]
public Nullable<DateTime> EarliestRestorePoint { get; }
Property Value
Nullable<DateTime>

FailoverGroupId

Gets instance Failover Group resource identifier that this managed database belongs to.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.failoverGroupId")]
public string FailoverGroupId { get; }
Property Value
String

RecoverableDatabaseId

Gets or sets the resource identifier of the recoverable database associated with create operation of this database.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.recoverableDatabaseId")]
public string RecoverableDatabaseId { get; set; }
Property Value
String

RestorableDroppedDatabaseId

Gets or sets the restorable dropped database resource id to restore when creating this database.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.restorableDroppedDatabaseId")]
public string RestorableDroppedDatabaseId { get; set; }
Property Value
String

RestorePointInTime

Gets or sets 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.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.restorePointInTime")]
public Nullable<DateTime> RestorePointInTime { get; set; }
Property Value
Nullable<DateTime>

SourceDatabaseId

Gets or sets the resource identifier of the source database associated with create operation of this database.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.sourceDatabaseId")]
public string SourceDatabaseId { get; set; }
Property Value
String

Status

Gets status of the database. Possible values include: 'Online', 'Offline', 'Shutdown', 'Creating', 'Inaccessible', 'Updating'

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.status")]
public string Status { get; }
Property Value
String

StorageContainerSasToken

Gets or sets conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the storage container sas token.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.storageContainerSasToken")]
public string StorageContainerSasToken { get; set; }
Property Value
String

StorageContainerUri

Gets or sets conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.

Declaration
[Newtonsoft.Json.JsonProperty(PropertyName="properties.storageContainerUri")]
public string StorageContainerUri { get; set; }
Property Value
String

Methods

Validate()

Validate the object.

Declaration
public override void Validate ();
Exceptions
ValidationException

Thrown if validation fails