az sql midb ltr-policy
Manage SQL Managed Instance database long term retention policy.
Name | Description | Type | Status |
---|---|---|---|
az sql midb ltr-policy set |
Update long term retention settings for a managed database. |
Core | Preview |
az sql midb ltr-policy show |
Show the long term retention policy for a managed database. |
Core | Preview |
This command is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Update long term retention settings for a managed database.
az sql midb ltr-policy set [--ids]
[--managed-instance]
[--monthly-retention]
[--name]
[--resource-group]
[--subscription]
[--week-of-year]
[--weekly-retention]
[--yearly-retention]
Set long term retention for a managed database.
az sql midb ltr-policy set -g mygroup --mi myinstance -n mymanageddb --weekly-retention "P1W" --monthly-retention "P6M" --yearly-retention "P1Y" --week-of-year 26
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.
Name of the Azure SQL Managed Instance.
Retention for the monthly backup. If just a number is passed instead of an ISO 8601 string, days will be assumed as the units.There is a minimum of 7 days and a maximum of 10 years.
The name of the Azure SQL Managed Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
The Week of Year, 1 to 52, in which to take the yearly LTR backup.
Retention for the weekly backup. If just a number is passed instead of an ISO 8601 string, days will be assumed as the units.There is a minimum of 7 days and a maximum of 10 years.
Retention for the yearly backup. If just a number is passed instead of an ISO 8601 string, days will be assumed as the units.There is a minimum of 7 days and a maximum of 10 years.
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.
This command is in preview and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Show the long term retention policy for a managed database.
az sql midb ltr-policy show [--ids]
[--managed-instance]
[--name]
[--resource-group]
[--subscription]
Show long term retention policy for a managed database.
az sql midb ltr-policy show -g mygroup --mi myinstance -n mymanageddb
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.
Name of the Azure SQL Managed Instance.
The name of the Azure SQL Managed Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
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: