az sql db ltr-backup
This command group is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Manage SQL database long term retention backups.
Name | Description | Type | Status |
---|---|---|---|
az sql db ltr-backup delete |
Delete a long term retention backup. |
Core | Preview |
az sql db ltr-backup list |
List the long term retention backups for a location, server or database. |
Core | Preview |
az sql db ltr-backup restore |
Restore a long term retention backup to a new database. |
Core | Preview |
az sql db ltr-backup show |
Get a long term retention backup for a database. |
Core | Preview |
az sql db ltr-backup wait |
Place the CLI in a waiting state until a condition of the database is met. |
Core | Preview |
Command group 'sql db ltr-backup' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Delete a long term retention backup.
az sql db ltr-backup delete --database
--location
--name
--server
[--yes]
Delete long term retention backup for database.
az sql db ltr-backup delete -l southeastasia -s myserver -d mydb -n "3214b3fb-fba9-43e7-96a3-09e35ffcb336;132292152080000000"
Name of the Azure SQL Database. If specified (along with server name), retrieves all requested backups under this database.
The location of the desired backups.
The name of the LTR backup. Use 'az sql db ltr-backup show' or 'az sql db ltr-backup list' for backup name.
Name of the Azure SQL Server. If specified, retrieves all requested backups under this server.
Do not prompt for confirmation.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Command group 'sql db ltr-backup' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
List the long term retention backups for a location, server or database.
az sql db ltr-backup list --location
[--database]
[--database-state]
[--latest]
[--resource-group]
[--server]
List long term retention backups for a database.
az sql db ltr-backup list -l southeastasia -s myserver -d mydb
List long term retention backups for a server (list only the latest LTR backups, which belong to live databases).
az sql db ltr-backup list -l southeastasia -s myserver --database-state Live --only-latest-per-database True
List long term retention backups for a server (with resource group argument).
az sql db ltr-backup list -l southeastasia -g mygroup -s myserver
List long term retention backups for a location (list only the latest LTR backups, which belong to live databases).
az sql db ltr-backup list -l southeastasia --database-state Live --only-latest-per-database True
List long term retention backups for a location (with resource group argument).
az sql db ltr-backup list -l southeastasia -g mygroup
The location of the desired backups.
Name of the Azure SQL Database. If specified (along with server name), retrieves all requested backups under this database.
'All', 'Live', or 'Deleted'. Will fetch backups only from databases of specified state. If no state provied, defaults to 'All'.
If true, will only return the latest backup for each database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. If specified, retrieves all requested backups under this server.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Command group 'sql db ltr-backup' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Restore a long term retention backup to a new database.
az sql db ltr-backup restore --backup-id
--dest-database
--dest-resource-group
--dest-server
[--assign-identity {false, true}]
[--auto-pause-delay]
[--availability-zone]
[--backup-storage-redundancy]
[--capacity]
[--compute-model {Provisioned, Serverless}]
[--edition]
[--elastic-pool]
[--encryption-protector]
[--encryption-protector-auto-rotation {false, true}]
[--family]
[--federated-client-id]
[--ha-replicas]
[--keys]
[--license-type {BasePrice, LicenseIncluded}]
[--min-capacity]
[--no-wait]
[--preferred-enclave-type {Default, VBS}]
[--read-scale {Disabled, Enabled}]
[--service-level-objective]
[--tags]
[--umi]
[--zone-redundant {false, true}]
Restore LTR backup.
az sql db ltr-backup restore \
--dest-database targetdb --dest-server myserver --dest-resource-group mygroup \
--backup-id "/subscriptions/6caa113c-794c-42f8-ab9d-878d8aa104dc/resourceGroups/mygroup/providers/Microsoft.Sql/locations/southeastasia/longTermRetentionServers/myserver/longTermRetentionDatabases/sourcedb/longTermRetentionBackups/3214b3fb-fba9-43e7-96a3-09e35ffcb336;132292152080000000"
The resource id of the long term retention backup to be restored. Use 'az sql db ltr-backup show' or 'az sql db ltr-backup list' for backup id.
Name of the database that will be created as the restore destination.
Name of the resource group of the server to restore database to.
Name of the server to restore database to.
Assign identity for database.
Time in minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled.
Availability zone.
Backup storage redundancy used to store backups. Allowed values include: Local, Zone, Geo, GeoZone.
The capacity component of the sku in integer number of DTUs or vcores.
The compute model of the database.
The edition component of the sku. Allowed values include: Basic, Standard, Premium, GeneralPurpose, BusinessCritical, Hyperscale.
The name or resource id of the elastic pool to create the database in.
Specifies the Azure key vault key to be used as database encryption protector key.
Specifies the database encryption protector key auto rotation flag. Can be either true, false or null.
The compute generation component of the sku (for vcore skus only). Allowed values include: Gen4, Gen5.
The federated client id for the SQL Database. It is used for cross tenant CMK scenario.
The number of high availability replicas to provision for the database. Only settable for Hyperscale edition.
The list of AKV keys for the SQL Database.
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 HybridBenefit.
Minimal capacity that database will always have allocated, if not paused.
Do not wait for the long-running operation to finish.
Specifies type of enclave for this resource.
If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica. This property is only settable for Premium and Business Critical databases.
The service objective for the new database. For example: Basic, S0, P1, GP_Gen4_1, GP_S_Gen5_8, BC_Gen5_2, HS_Gen5_32.
Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.
The list of user assigned identity for the SQL Database.
Specifies whether to enable zone redundancy. Default is true if no value is specified.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Command group 'sql db ltr-backup' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Get a long term retention backup for a database.
az sql db ltr-backup show --database
--location
--name
--server
Show long term retention backup for a database.
az sql db ltr-backup show -l southeastasia -s myserver -d mydb -n "3214b3fb-fba9-43e7-96a3-09e35ffcb336;132292152080000000;Hot"
Name of the Azure SQL Database. If specified (along with server name), retrieves all requested backups under this database.
The location of the desired backups.
The name of the LTR backup. Use 'az sql db ltr-backup show' or 'az sql db ltr-backup list' for backup name.
Name of the Azure SQL Server. If specified, retrieves all requested backups under this server.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Command group 'sql db ltr-backup' is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Place the CLI in a waiting state until a condition of the database is met.
az sql db ltr-backup wait [--created]
[--custom]
[--deleted]
[--exists]
[--expand]
[--filter]
[--ids]
[--interval]
[--name]
[--resource-group]
[--server]
[--subscription]
[--timeout]
[--updated]
Wait until created with 'provisioningState' at 'Succeeded'.
Wait until the condition satisfies a custom JMESPath query. E.g. provisioningState!='InProgress', instanceView.statuses[?code=='PowerState/running'].
Wait until deleted.
Wait until the resource exists.
The child resources to include in the response. Default value is None.
An OData filter expression that filters elements in the collection. Default value is None.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Polling interval in seconds.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Maximum wait in seconds.
Wait until updated with provisioningState at 'Succeeded'.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Azure CLI feedback
Azure CLI is an open source project. Select a link to provide feedback: