你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
DatabaseUpdateInner 构造函数
定义
重要
一些信息与预发行产品相关,相应产品在发行之前可能会进行重大修改。 对于此处提供的信息,Microsoft 不作任何明示或暗示的担保。
重载
DatabaseUpdateInner()
初始化 DatabaseUpdateInner 类的新实例。
public DatabaseUpdateInner ();
Public Sub New ()
适用于
DatabaseUpdateInner(String, String, String, IDictionary<String, String>, String, Nullable<DateTime>, Nullable<Int64>, Nullable<Guid>, Nullable<Guid>, Nullable<DateTime>, CreateMode, String, Nullable<DateTime>, Nullable<DateTime>, String, DatabaseEdition, String, Nullable<Guid>, ServiceObjectiveName, ServiceObjectiveName, String, String, String, IList<ServiceTierAdvisorInner>, IList<TransparentDataEncryptionInner>, IList<RecommendedIndex>, String, Nullable<ReadScale>, SampleName, Nullable<Boolean>)
初始化 DatabaseUpdateInner 类的新实例。
public DatabaseUpdateInner (string id = default, string name = default, string type = default, System.Collections.Generic.IDictionary<string,string> tags = default, string collation = default, DateTime? creationDate = default, long? containmentState = default, Guid? currentServiceObjectiveId = default, Guid? databaseId = default, DateTime? earliestRestoreDate = default, Microsoft.Azure.Management.Sql.Fluent.Models.CreateMode createMode = default, string sourceDatabaseId = default, DateTime? sourceDatabaseDeletionDate = default, DateTime? restorePointInTime = default, string recoveryServicesRecoveryPointResourceId = default, Microsoft.Azure.Management.Sql.Fluent.Models.DatabaseEdition edition = default, string maxSizeBytes = default, Guid? requestedServiceObjectiveId = default, Microsoft.Azure.Management.Sql.Fluent.Models.ServiceObjectiveName requestedServiceObjectiveName = default, Microsoft.Azure.Management.Sql.Fluent.Models.ServiceObjectiveName serviceLevelObjective = default, string status = default, string elasticPoolName = default, string defaultSecondaryLocation = default, System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.ServiceTierAdvisorInner> serviceTierAdvisors = default, System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.TransparentDataEncryptionInner> transparentDataEncryption = default, System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndex> recommendedIndex = default, string failoverGroupId = default, Microsoft.Azure.Management.Sql.Fluent.Models.ReadScale? readScale = default, Microsoft.Azure.Management.Sql.Fluent.Models.SampleName sampleName = default, bool? zoneRedundant = default);
new Microsoft.Azure.Management.Sql.Fluent.Models.DatabaseUpdateInner : string * string * string * System.Collections.Generic.IDictionary<string, string> * string * Nullable<DateTime> * Nullable<int64> * Nullable<Guid> * Nullable<Guid> * Nullable<DateTime> * Microsoft.Azure.Management.Sql.Fluent.Models.CreateMode * string * Nullable<DateTime> * Nullable<DateTime> * string * Microsoft.Azure.Management.Sql.Fluent.Models.DatabaseEdition * string * Nullable<Guid> * Microsoft.Azure.Management.Sql.Fluent.Models.ServiceObjectiveName * Microsoft.Azure.Management.Sql.Fluent.Models.ServiceObjectiveName * string * string * string * System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.ServiceTierAdvisorInner> * System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.TransparentDataEncryptionInner> * System.Collections.Generic.IList<Microsoft.Azure.Management.Sql.Fluent.Models.RecommendedIndex> * string * Nullable<Microsoft.Azure.Management.Sql.Fluent.Models.ReadScale> * Microsoft.Azure.Management.Sql.Fluent.Models.SampleName * Nullable<bool> -> Microsoft.Azure.Management.Sql.Fluent.Models.DatabaseUpdateInner
Public Sub New (Optional id As String = Nothing, Optional name As String = Nothing, Optional type As String = Nothing, Optional tags As IDictionary(Of String, String) = Nothing, Optional collation As String = Nothing, Optional creationDate As Nullable(Of DateTime) = Nothing, Optional containmentState As Nullable(Of Long) = Nothing, Optional currentServiceObjectiveId As Nullable(Of Guid) = Nothing, Optional databaseId As Nullable(Of Guid) = Nothing, Optional earliestRestoreDate As Nullable(Of DateTime) = Nothing, Optional createMode As CreateMode = Nothing, Optional sourceDatabaseId As String = Nothing, Optional sourceDatabaseDeletionDate As Nullable(Of DateTime) = Nothing, Optional restorePointInTime As Nullable(Of DateTime) = Nothing, Optional recoveryServicesRecoveryPointResourceId As String = Nothing, Optional edition As DatabaseEdition = Nothing, Optional maxSizeBytes As String = Nothing, Optional requestedServiceObjectiveId As Nullable(Of Guid) = Nothing, Optional requestedServiceObjectiveName As ServiceObjectiveName = Nothing, Optional serviceLevelObjective As ServiceObjectiveName = Nothing, Optional status As String = Nothing, Optional elasticPoolName As String = Nothing, Optional defaultSecondaryLocation As String = Nothing, Optional serviceTierAdvisors As IList(Of ServiceTierAdvisorInner) = Nothing, Optional transparentDataEncryption As IList(Of TransparentDataEncryptionInner) = Nothing, Optional recommendedIndex As IList(Of RecommendedIndex) = Nothing, Optional failoverGroupId As String = Nothing, Optional readScale As Nullable(Of ReadScale) = Nothing, Optional sampleName As SampleName = Nothing, Optional zoneRedundant As Nullable(Of Boolean) = Nothing)
参数
- id
- String
- name
- String
- type
- String
- tags
- IDictionary<String,String>
资源标记。
- collation
- String
数据库的排序规则。 如果 createMode 不是 Default,则忽略此值。
- createMode
- CreateMode
指定数据库创建模式。
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 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 specified as the
recovery point resource ID.
Copy, NonReadableSecondary, OnlineSecondary and
RestoreLongTermRetentionBackup are not supported for DataWarehouse
edition. Possible values include: 'Copy', 'Default',
'NonReadableSecondary', 'OnlineSecondary', 'PointInTimeRestore',
'Recovery', 'Restore', 'RestoreLongTermRetentionBackup'
- sourceDatabaseId
- String
条件。 如果 createMode 为 Copy、NonReadableSecondary、OnlineSecondary、PointInTimeRestore、Recovery 或 Restore,则此值是必需的。 指定源数据库的资源 ID。 如果 createMode 为 NonReadableSecondary 或 OnlineSecondary,则源数据库的名称必须与正在创建的新数据库相同。
条件。 如果 createMode 为 Restore,而 sourceDatabaseId 是已删除数据库 (的原始资源 ID,而不是) 当前可还原的已删除数据库 ID,则此值是必需的。 指定删除数据库的时间。
条件。 如果 createMode 为 PointInTimeRestore,则此值是必需的。 如果 createMode 为 Restore,则此值是可选的。 指定将还原为创建新数据库的源数据库的时间点 (ISO8601 格式) 。 必须大于或等于源数据库的最早RestoreDate 值。
- recoveryServicesRecoveryPointResourceId
- String
条件。 如果 createMode 为 RestoreLongTermRetentionBackup,则此值是必需的。 指定要从中还原的恢复点的资源 ID。
- edition
- DatabaseEdition
数据库的版本。 DatabaseEditions 枚举包含所有有效版本。 如果 createMode 为 NonReadableSecondary 或 OnlineSecondary,则忽略此值。
The list of SKUs may vary by region and support offer. To determine
the SKUs (including the SKU name, tier/edition, family, and
capacity) that are available to your subscription in an Azure
region, use the `Capabilities_ListByLocation` REST API or one of
the following commands:
```azurecli
az sql db list-editions -l <location> -o table
````
```powershell
Get-AzSqlServerServiceObjective -Location <location>
````
. Possible values include: 'Web', 'Business', 'Basic', 'Standard',
'Premium', 'PremiumRS', 'Free', 'Stretch', 'DataWarehouse',
'System', 'System2', 'GeneralPurpose', 'BusinessCritical',
'Hyperscale'
- maxSizeBytes
- String
以字节表示的数据库的最大大小。 如果 createMode 不是 Default,则忽略此值。 若要查看可能的值,请查询 operationId 引用的功能 API (/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/{locationID}/capabilities) :“Capabilities_ListByLocation”。
数据库的已配置服务级别目标 ID。 这是正在应用于数据库的服务级别目标。 成功更新后,它将匹配 currentServiceObjectiveId 属性的值。 如果 requestedServiceObjectiveId 和 requestedServiceObjectiveName 均已更新,则 requestedServiceObjectiveId 的值将替代 requestedServiceObjectiveName 的值。
The list of SKUs may vary by region and support offer. To determine
the service objective ids that are available to your subscription
in an Azure region, use the `Capabilities_ListByLocation` REST
API.
- requestedServiceObjectiveName
- ServiceObjectiveName
数据库的已配置服务级别目标的名称。 这是正在应用于数据库的服务级别目标。 成功更新后,它将匹配 serviceLevelObjective 属性的值。
The list of SKUs may vary by region and support offer. To determine
the SKUs (including the SKU name, tier/edition, family, and
capacity) that are available to your subscription in an Azure
region, use the `Capabilities_ListByLocation` REST API or one of
the following commands:
```azurecli
az sql db list-editions -l <location> -o table
````
```powershell
Get-AzSqlServerServiceObjective -Location <location>
````
. Possible values include: 'System', 'System0', 'System1',
'System2', 'System3', 'System4', 'System2L', 'System3L',
'System4L', 'Free', 'Basic', 'S0', 'S1', 'S2', 'S3', 'S4', 'S6',
'S7', 'S9', 'S12', 'P1', 'P2', 'P3', 'P4', 'P6', 'P11', 'P15',
'PRS1', 'PRS2', 'PRS4', 'PRS6', 'DW100', 'DW200', 'DW300', 'DW400',
'DW500', 'DW600', 'DW1000', 'DW1200', 'DW1000c', 'DW1500',
'DW1500c', 'DW2000', 'DW2000c', 'DW3000', 'DW2500c', 'DW3000c',
'DW6000', 'DW5000c', 'DW6000c', 'DW7500c', 'DW10000c', 'DW15000c',
'DW30000c', 'DS100', 'DS200', 'DS300', 'DS400', 'DS500', 'DS600',
'DS1000', 'DS1200', 'DS1500', 'DS2000', 'ElasticPool'
- serviceLevelObjective
- ServiceObjectiveName
数据库的当前服务级别目标。 可能的值包括:“System”、“System0”、“System1”、“System2”、“System3”、“System4”、“System2L”、 'System3L', 'System4L', 'Free', 'Basic', 'S0', 'S1', 'S2', 'S3', 'S4', 'S6', 'S7', 'S9', 'S12', 'P1', 'P2', 'P3', 'P4', 'P6', 'P11', 'P15', “PRS1”、“PRS2”、“PRS4”、“PRS6”、“DW100”、“DW200”、“DW300”、“DW400”、“DW500”、“DW600”、“DW1000”、“DW1000”、“DW1200”、“DW1000c”、“DW1500”、“DW1500”、“DW1500”0c“、”DW2000“、”DW2000c“、”DW3000“、”DW2500c“、”DW3000c“、”DW6000“、”DW5000c“、”DW6000c“、”DW6000c“、”DW7500c“、”DW10000c“、”DW15000c“、 “DW30000c”、“DS100”、“DS200”、“DS300”、“DS400”、“DS500”、“DS600”、“DS1000”、“DS1200”、“DS1500”、“DS2000”、“ElasticPool”
- status
- String
数据库的状态。
- elasticPoolName
- String
数据库所位于的弹性池的名称。 如果 elasticPoolName 和 requestedServiceObjectiveName 均已更新,则忽略 requestedServiceObjectiveName 的值。 DataWarehouse 版本不支持。
- defaultSecondaryLocation
- String
此数据库的默认次要区域。
- serviceTierAdvisors
- IList<ServiceTierAdvisorInner>
此数据库的服务层顾问列表。 展开的属性
- transparentDataEncryption
- IList<TransparentDataEncryptionInner>
此数据库的透明数据加密信息。
- recommendedIndex
- IList<RecommendedIndex>
此数据库的建议索引。
- failoverGroupId
- String
包含此数据库的故障转移组的资源标识符。
条件。 如果数据库是异地辅助数据库,readScale 指示是否允许到此数据库的只读连接。 DataWarehouse 版本不支持。 可能的值包括:“Enabled”、“Disabled”
- sampleName
- SampleName
指示创建此数据库时要应用的示例架构的名称。 如果 createMode 不是 Default,则忽略此值。 DataWarehouse 版本不支持。 可能的值包括:“AdventureWorksLT”