Package-level declarations

Type of the sever administrator.

Type of enclave requested on the elastic pool.

The managed instance's authentication metadata lookup mode.

Gets the auto-execute status (whether to let the system execute the recommendations) of this advisor. Possible values are 'Enabled' and 'Disabled'

Specifies the availability zone the pool's primary replica is pinned to.

The BackupStorageAccessTier for the LTR backups

The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)

Specifies the state of the audit. If state is Enabled, storageEndpoint or isAzureMonitorTargetEnabled are required.

Collation of the metadata catalog.

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. Secondary: creates a database as a 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, Secondary, and RestoreLongTermRetentionBackup are not supported for DataWarehouse edition.

The identity type

The license type to apply for this database. LicenseIncluded if you need a license, or BasePrice if you have a license and are eligible for the Azure Hybrid Benefit.

The state of read-only routing. If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica in the same region. Not applicable to a Hyperscale database within an elastic pool.

The state of the data masking policy.

Stop day.

The license type to apply for this elastic pool.

Databases secondary type on partner server.

The link failover mode - can be Manual if intended to be used for two-way failover with a supported SQL Server, or None for one-way failover to Azure.

Specifies the behavior when monthly free limits are exhausted for the free database. AutoPause: The database will be auto paused upon exhaustion of free limits for remainder of the month. BillForUsage: The database will continue to be online upon exhaustion of free limits and any overage will be billed.

The state of the geo backup policy.

Hybrid secondary usage. Possible values are 'Active' (default value) and 'Passive' (customer uses the secondary as Passive DR).

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

The license type. Possible values are 'LicenseIncluded' (price for SQL license is included) and 'BasePrice' (without SQL license price).

The job agent identity type

Schedule interval type

The source of the action to execute.

Type of action being executed by the job step.

The output destination type.

Whether the target is included or excluded from the group.

The target type.

Managed instance side link role

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).

Type of the managed instance administrator.

Specifies the internal format of instance databases specific to the SQL engine version.

The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).

Connection type used for connecting to the instance.

Specifies the mode of database creation. Default: Regular instance creation. Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

Minimal TLS version. Allowed values: 'None', 1.0', '1.1', '1.2', '1.3'

Pricing model of Managed Instance.

Principal Type of the sever administrator.

The private link service connection status.

Failover policy of the read-only endpoint for the failover group.

Failover policy of the read-write endpoint for the failover group. If failoverPolicy is Automatic then failoverWithDataLossGracePeriodMinutes is required.

Link type (GEO, NAMED, STANDBY). Update operation does not support NAMED.

Replication mode of the link

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

Type of the geo-secondary instance. Set 'Standby' if the instance is used as a DR option only.

The secondary type of the database if it is a secondary. Valid values are Geo, Named and Standby.

Specifies that the alert is sent to the account administrators.

Specifies the state of the policy. If state is Enabled, storageEndpoint and storageAccountAccessKey are required.

Specifies whether to use the default server policy.

Specifies the state of the policy, whether it is enabled or disabled or a policy has not been applied yet on the specific database.

Database seeding mode – can be Automatic (default), or Manual for supported scenarios.

The server key type like 'ServiceManaged', 'AzureKeyVault'.

Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'

Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled' or 'SecuredByPerimeter'

Service principal type.

Specifies the state of the SQL Vulnerability Assessment, whether it is enabled or disabled or a state has not been applied yet on the specific database or server.

Conflict resolution policy of the sync group.

Sync direction of the sync member.

Database type of the sync member.

Specifies the state of the transparent data encryption.