Каталог микроволновок понасоник

Databases - Create Or Update

Creates a new database or updates an existing database.

URI Parameters

NameInRequiredTypeDescription

subscriptionId

path True

The subscription ID that identifies an Azure subscription.

resourceGroupName

path True

The name of the resource group that contains the resource.

You can obtain this value from the Azure Resource Manager API or the portal.

serverName

path True

The name of the server.

databaseName

path True

The name of the database to be operated on (updated or created).

api-version

query True

The API version to use for the request.

Request Body

NameRequiredTypeDescription
location True

Resource location.

seo-traf.ruion

The collation of the каталог микроволновок понасоник.

If createMode is not Каталог микроволновок понасоник, this каталог микроволновок понасоник is ignored.

seo-traf.ruMode

Specifies the mode of database creation.

Default: regular database creation.

Copy: creates a database as a copy of an existing database.

sourceDatabaseId must be specified as the resource ID of the source database.

OnlineSecondary/NonReadableSecondary: creates a database as a (readable or nonreadable) secondary replica of an existing database. sourceDatabaseId must be specified as the resource ID каталог микроволновок понасоник the existing primary database.

PointInTimeRestore: Creates a database by restoring a каталог микроволновок понасоник in time backup of an existing database.

sourceDatabaseId must be specified as the resource ID of the existing database, and restorePointInTime must be specified.

Recovery: Creates a database by restoring a geo-replicated backup.

sourceDatabaseId must be specified as the recoverable database resource ID to restore.

Restore: Creates a database by restoring a backup каталог микроволновок понасоник a deleted database. sourceDatabaseId must be specified. If sourceDatabaseId is the database's original resource ID, then sourceDatabaseDeletionDate must be specified. Otherwise sourceDatabaseId must be the restorable dropped database resource ID and sourceDatabaseDeletionDate is ignored. restorePointInTime may also be specified to restore from каталог микроволновок понасоник earlier point in time.

RestoreLongTermRetentionBackup: Creates каталог микроволновок понасоник database by restoring from a long term retention vault.

recoveryServicesRecoveryPointResourceId must be specified as the recovery point resource ID.

Copy, NonReadableSecondary, OnlineSecondary and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition.

seo-traf.run

The edition of the database. The DatabaseEditions enumeration contains all the valid editions.

If createMode is NonReadableSecondary or OnlineSecondary, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

seo-traf.rucPoolName

The name of the elastic pool the database is in.

If elasticPoolName and requestedServiceObjectiveName are both updated, the value of requestedServiceObjectiveName is ignored. Not supported for DataWarehouse edition.

каталог микроволновок понасоник

The max size of the database expressed in bytes.

If createMode is not Default, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation."

seo-traf.ruale

Conditional.

If the database is a geo-secondary, readScale indicates whether read-only connections are allowed to this database or not. Not supported for DataWarehouse edition.

seo-traf.ruryServicesRecoveryPointResourceId

Conditional.

If createMode is RestoreLongTermRetentionBackup, then this value is required. Specifies the resource ID of the recovery point to restore from.

seo-traf.rutedServiceObjectiveId

The configured service level objective ID of the database.

This is the service каталог микроволновок понасоник objective that is in the process of being applied to the database. Once successfully updated, it will match the value of currentServiceObjectiveId property. If requestedServiceObjectiveId and requestedServiceObjectiveName are both updated, the value каталог микроволновок понасоник requestedServiceObjectiveId overrides the value of requestedServiceObjectiveName.

To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

seo-traf.rutedServiceObjectiveName

The name of the configured service level objective of the database. This is the service level objective that is in the process of being applied to the database.

Once successfully updated, it will match the value of serviceLevelObjective property. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

seo-traf.ruePointInTime

Conditional.

If createMode is PointInTimeRestore, this каталог микроволновок понасоник is required. If createMode is Restore, this value is optional. Specifies the point in time (ISO format) of the source database that will каталог микроволновок понасоник restored to create каталог микроволновок понасоник new database.

Must be greater than or equal to the source database's earliestRestoreDate value.

seo-traf.ruName

Indicates the name of the sample schema to apply when creating this database. If createMode is not Default, this value is ignored. Not supported for DataWarehouse каталог микроволновок понасоник seo-traf.ruDatabaseDeletionDate

Conditional.

If createMode is Restore and sourceDatabaseId is the deleted database's original resource id when it existed (as opposed to its current restorable dropped database id), then this value is required. Specifies the time that the database was deleted.

seo-traf.ruDatabaseId

Conditional. If createMode is Copy, NonReadableSecondary, OnlineSecondary, PointInTimeRestore, Recovery, or Restore, then this value is required.

Specifies the resource ID of the source database. If createMode is NonReadableSecondary or OnlineSecondary, the name of the source database must be the same as the new database being created.

seo-traf.rudundant

Whether or not this database is zone redundant, which means the replicas of this каталог микроволновок понасоник will be spread across multiple availability zones.

tags
  • <string, string>

Resource tags.

Responses

NameTypeDescription
OK

OK

Created

Created

Accepted

Accepted

Examples

Create a database as a copy

Sample Request

Sample Response

Create a database as a dropped database restore to a specific point in time

Sample Request

Sample Response

Create a database as a dropped database restore to deletion time

Sample Request

Sample Response

Create a database as a geo restore

Sample Request

Sample Response

Create a database as a non-readable secondary

Sample Request

Sample Response

Create a database as a каталог микроволновок понасоник in time каталог микроволновок понасоник Request

Sample Response

Create a database as an online secondary

Sample Каталог микроволновок понасоник Response

Create a database from a long term retention backup

Sample Request

Sample Response

Create a database max

Sample Request

Sample Response

Create a database min

Sample Request

Sample Response

Update a database's elastic pool'

Sample Request

Sample Response

Update a database max

Sample Request

Sample Response

Definitions

CreateMode

Specifies the mode of database creation.

Default: regular database creation.

Copy: creates a database as a copy of an existing database.

sourceDatabaseId must be specified as the resource ID of the source database.

OnlineSecondary/NonReadableSecondary: creates a database as a (readable or nonreadable) secondary replica of an existing database. каталог микроволновок понасоник must be specified as the resource ID of the existing primary database.

PointInTimeRestore: Creates a database by restoring a point in time backup of an existing database.

sourceDatabaseId must be specified as the resource ID of the existing database, and restorePointInTime must be specified.

Recovery: Creates a database by restoring a geo-replicated backup. sourceDatabaseId must be specified as the recoverable database resource ID to restore.

Restore: Creates a database by restoring a backup of a deleted database.

sourceDatabaseId must be specified. If sourceDatabaseId is the database's original resource ID, then sourceDatabaseDeletionDate must be specified.

каталог микроволновок понасоник

Otherwise sourceDatabaseId must be the restorable dropped database resource ID and sourceDatabaseDeletionDate is ignored. restorePointInTime may also be specified to restore from an earlier point in time.

RestoreLongTermRetentionBackup: Creates a database by restoring from a long term retention vault.

recoveryServicesRecoveryPointResourceId must be каталог микроволновок понасоник as the recovery point resource ID.

Copy, NonReadableSecondary, OnlineSecondary and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition.

Database

Represents a database.

DatabaseEdition

The edition of the database.

The DatabaseEditions enumeration contains all the valid editions. If createMode is NonReadableSecondary or OnlineSecondary, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." каталог микроволновок понасоник use the Azure CLI command .

OperationImpact

The impact of an operation, both in absolute каталог микроволновок понасоник relative terms.

ReadScale

Conditional.

If the database is a geo-secondary, readScale indicates whether read-only connections are allowed to this database or not. Not supported for DataWarehouse edition.

RecommendedIndex

Represents a database recommended index.

RecommendedIndexAction

The proposed index action.

You can create a missing index, drop an unused index, or rebuild каталог микроволновок понасоник existing index to improve its performance.

RecommendedIndexState

The current recommendation state.

RecommendedIndexType

The type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE)

SampleName

Indicates the name каталог микроволновок понасоник the sample schema to apply when creating this database.

If createMode is not Default, this value is ignored. Not supported for DataWarehouse edition.

ServiceObjectiveName

The name of the configured service level objective of the database. This is the service level objective that is in the process of being applied to the database. Once каталог микроволновок понасоник updated, it will match the value of serviceLevelObjective property.

To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

ServiceTierAdvisor

Represents a Service Tier Advisor.

SloUsageMetric

A Slo Usage Metric.

TransparentDataEncryption

Represents a database transparent data encryption configuration.

TransparentDataEncryptionStatus

The status of the database transparent data encryption.

CreateMode

Specifies the mode of database creation.

Default: regular database creation.

Copy: creates a database as a copy of an existing database.

sourceDatabaseId must be specified as the resource ID of the source database.

OnlineSecondary/NonReadableSecondary: creates a database as a (readable or каталог микроволновок понасоник secondary replica of an existing database.

sourceDatabaseId must be specified as the resource ID of the existing primary database.

PointInTimeRestore: Creates a database by restoring a point in time backup of an existing database. sourceDatabaseId must be specified as the resource ID of the existing каталог микроволновок понасоник, and restorePointInTime must be specified.

Recovery: Creates a database by restoring a geo-replicated backup.

sourceDatabaseId must be specified as каталог микроволновок понасоник recoverable database resource ID to restore.

Restore: Creates a database by restoring a backup of a deleted database.

sourceDatabaseId must be specified. If sourceDatabaseId is the database's original resource ID, then sourceDatabaseDeletionDate must be specified. Otherwise sourceDatabaseId must be the restorable dropped database resource ID and sourceDatabaseDeletionDate is ignored.

restorePointInTime may also be specified to restore from an earlier point in time.

RestoreLongTermRetentionBackup: Creates a database by restoring from a long term retention vault. recoveryServicesRecoveryPointResourceId must be specified as the recovery point resource ID.

Copy, NonReadableSecondary, OnlineSecondary and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition.

NameTypeDescription
Copy
каталог микроволновок понасоник
NonReadableSecondary
OnlineSecondary
каталог микроволновок понасоник
Recovery
Restore
RestoreLongTermRetentionBackup

Database

Represents a database.

NameTypeDescription
id

Resource ID.

kind каталог микроволновок понасоник of database.

This каталог микроволновок понасоник metadata used for the Azure portal experience.

location

Resource location.

name

Resource name.

seo-traf.ruion

The collation of the database.

If createMode is not Default, this value is ignored.

seo-traf.runmentState

The containment state of the database.

seo-traf.ruMode

Specifies the mode of database creation.

Default: regular database creation.

Copy: creates a database as a copy of an existing database.

sourceDatabaseId must be specified as the resource ID of the source database.

OnlineSecondary/NonReadableSecondary: creates a database as a (readable or nonreadable) secondary replica of an existing database. sourceDatabaseId must be specified as the resource ID of the existing primary database.

PointInTimeRestore: Creates a database by каталог микроволновок понасоник a point in time backup of an existing database.

sourceDatabaseId must be specified as the resource ID of the existing database, and restorePointInTime must be specified.

Recovery: Creates a database by restoring a geo-replicated backup. sourceDatabaseId must be specified as the recoverable database resource ID to restore.

Restore: Creates a database by restoring a backup of a deleted database.

sourceDatabaseId must be specified. If sourceDatabaseId is the database's original resource ID, then sourceDatabaseDeletionDate must be specified.

Otherwise sourceDatabaseId must be the restorable dropped database resource ID and sourceDatabaseDeletionDate is ignored. restorePointInTime may also be specified to restore from an earlier point in time.

RestoreLongTermRetentionBackup: Каталог микроволновок понасоник a database by restoring from a long term retention vault.

recoveryServicesRecoveryPointResourceId must be specified as the recovery point resource ID.

Copy, NonReadableSecondary, OnlineSecondary and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition.

seo-traf.ruonDate

The creation date of the database (ISO format).

seo-traf.rutServiceObjectiveId

The current service level objective ID of the database.

This is the ID of the service level objective that is currently active.

seo-traf.ruseId

The ID of the database.

seo-traf.rutSecondaryLocation

The default secondary region for this database.

seo-traf.rustRestoreDate

This records the earliest start date and time that restore is available for this database (ISO каталог микроволновок понасоник seo-traf.run

The edition of the database.

The DatabaseEditions enumeration contains all the valid editions. If createMode is NonReadableSecondary or OnlineSecondary, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) каталог микроволновок понасоник to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

seo-traf.rucPoolName

The name of the elastic pool the database is in.

If elasticPoolName and requestedServiceObjectiveName are both updated, the value of requestedServiceObjectiveName is ignored. Not supported for DataWarehouse edition.

seo-traf.ruerGroupId

The resource identifier of the failover group containing this database.

seo-traf.rueBytes

The max size of the database expressed in bytes.

If createMode is not Default, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation."

seo-traf.ruale

Conditional.

If the database is каталог микроволновок понасоник geo-secondary, readScale indicates whether read-only connections are allowed to this database or not. Not supported for DataWarehouse edition.

seo-traf.ruendedIndex

The recommended indices for this database.

seo-traf.ruryServicesRecoveryPointResourceId

Conditional. If createMode is RestoreLongTermRetentionBackup, then this value is required.

Specifies the resource ID of the recovery point to restore from.

seo-traf.rutedServiceObjectiveId

The configured service level objective ID of the database. This is the service level objective that is in the process of being applied to the database. Once successfully updated, it will match the value of currentServiceObjectiveId property. If requestedServiceObjectiveId and requestedServiceObjectiveName are both updated, the value of requestedServiceObjectiveId overrides the value of requestedServiceObjectiveName.

To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

каталог микроволновок понасоник

The name of the configured service level objective of каталог микроволновок понасоник database.

This is the service level objective that is каталог микроволновок понасоник the process of being applied to the database. Once successfully updated, it will match the value of serviceLevelObjective property. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

seo-traf.ruePointInTime

Conditional.

If каталог микроволновок понасоник is PointInTimeRestore, this value is required. If createMode is Restore, this value is optional. Specifies the point in time (ISO format) of the source database that will be restored to create the new database. Must be greater каталог микроволновок понасоник or equal to the source database's earliestRestoreDate value.

seo-traf.ruName

Indicates the name of the sample schema to apply when creating this database.

If createMode is not Default, this value is ignored. Not supported for DataWarehouse edition.

seo-traf.rueLevelObjective каталог микроволновок понасоник current service level objective of the database.

seo-traf.rueTierAdvisors

The list of service tier advisors for this database.

Expanded property

seo-traf.ruDatabaseDeletionDate

Conditional. If createMode is Restore and sourceDatabaseId is the deleted database's original resource id when it existed (as opposed to its current restorable dropped database id), then this value is required.

Specifies the time that the database was deleted.

seo-traf.ruDatabaseId

Conditional. If createMode is Copy, NonReadableSecondary, OnlineSecondary, PointInTimeRestore, Recovery, or Restore, then this value is required. Specifies каталог микроволновок понасоник resource ID of the source database. If createMode is NonReadableSecondary or OnlineSecondary, the name of the source database must be the same as the new database being created.

seo-traf.ru

The status of the database.

seo-traf.ruarentDataEncryption

The transparent data каталог микроволновок понасоник info for this database.

seo-traf.rudundant

Whether or not this database каталог микроволновок понасоник zone redundant, which means the replicas of this database will be spread across multiple availability zones.

tags
  • <string, string>

Resource tags.

type

Resource type.

DatabaseEdition

The edition of the database.

The DatabaseEditions enumeration contains all the valid editions. If createMode is NonReadableSecondary or OnlineSecondary, this value is ignored. To see possible values, query the capabilities API (/subscriptions/{subscriptionId}/providers/seo-traf.ru{locationID}/capabilities) referred to by operationId: "Capabilities_ListByLocation." or use the Azure CLI command .

NameTypeDescription
Basic
Business
DataWarehouse
Free
Premium
PremiumRS
Standard
Stretch
System
System2
Web

OperationImpact

The impact of an operation, both in absolute and relative terms.

NameTypeDescription
changeValueAbsolute

The absolute impact to dimension.

changeValueRelative

The relative impact to dimension (null if not applicable)

name

The name каталог микроволновок понасоник the impact dimension.

unit

The unit in which estimated impact to dimension is measured.

ReadScale

Conditional.

If the database is a geo-secondary, readScale indicates whether read-only connections are allowed to this database каталог микроволновок понасоник not. Not supported for DataWarehouse edition.

NameTypeDescription
Disabled
Enabled

RecommendedIndex

Represents a database recommended index.

NameTypeDescription
id

Resource ID.

name

Resource name.

seo-traf.ru

The proposed index action.

You can create a missing index, drop an unused index, or rebuild an existing index to improve its performance.

seo-traf.rus

Columns over which to build index

seo-traf.rud

The UTC datetime showing when this resource was created (ISO format).

seo-traf.rutedImpact

The estimated impact of doing recommended index action.

seo-traf.ruedColumns

The list of column names to каталог микроволновок понасоник included in the index

seo-traf.rucript

The full build index script

seo-traf.ruype

The type of index (CLUSTERED, NONCLUSTERED, COLUMNSTORE, CLUSTERED COLUMNSTORE)

seo-traf.rudified

The UTC datetime of when was this resource last changed (ISO format).

seo-traf.ruedImpact

The values reported after index action is complete.

seo-traf.ru

The schema where table to build index over resides

seo-traf.ru

The current recommendation state.

seo-traf.ru

The table on which to build index.

type

Resource type.

RecommendedIndexAction

The proposed index action.

You can create a missing index, drop an unused index, or rebuild an existing index to improve its performance.

NameTypeDescription
Create
Drop
Rebuild

RecommendedIndexState

The current recommendation state.

NameTypeDescription
Active
каталог микроволновок понасоник
Executing
Expired
Ignored
Pending
Pending Revert
Reverted
Reverting
Success
Источник: seo-traf.ru