az sql midb short-term-retention-policy

Manage SQL Managed Instance database backup short term retention policy.

Commands

az sql midb short-term-retention-policy set

Update short term retention for automated backups on a single database.

az sql midb short-term-retention-policy show

Show short term retention for automated backups on a single database.

az sql midb short-term-retention-policy set

Update short term retention for automated backups on a single database.

az sql midb short-term-retention-policy set --retention-days
                                            [--deleted-time]
                                            [--ids]
                                            [--managed-instance]
                                            [--name]
                                            [--no-wait]
                                            [--resource-group]
                                            [--subscription]

Examples

Set backup short term retention for live managed database.

az sql midb short-term-retention-policy set -g mygroup --mi myinstance -n mymanageddb --retention-days retentionindays

Set backup short term retention for dropped managed database.

az sql midb short-term-retention-policy set -g mygroup --mi myinstance -n mymanageddb --deleted-time "2018-05-20T05:34:22" --retention-days retentionindays

Required Parameters

--retention-days

New backup short term retention policy in days.Valid policy for live database is 7-35 days, valid policy for dropped databases is 0-35 days.

Optional Parameters

--deleted-time

If specified, updates retention days for a deleted database, instead of an existing database.Must match the deleted time of a deleted database on the source Managed Instance.

--ids

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.

--managed-instance --mi

Name of the Azure SQL managed instance.

--name -n

The name of the Azure SQL Managed Database.

--no-wait

Do not wait for the long-running operation to finish.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql midb short-term-retention-policy show

Show short term retention for automated backups on a single database.

az sql midb short-term-retention-policy show [--deleted-time]
                                             [--ids]
                                             [--managed-instance]
                                             [--name]
                                             [--query-examples]
                                             [--resource-group]
                                             [--subscription]

Examples

Shows backup short term retention for live managed database.

az sql midb short-term-retention-policy show -g mygroup --mi myinstance -n mymanageddb

Show backup short term retention for dropped managed database.

az sql midb short-term-retention-policy show -g mygroup --mi myinstance -n mymanageddb --deleted-time "2018-05-20T05:34:22"

Optional Parameters

--deleted-time

If specified, shows retention days for a deleted database, instead of an existing database.Must match the deleted time of a deleted database on the source Managed Instance.

--ids

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.

--managed-instance --mi

Name of the Azure SQL managed instance.

--name -n

The name of the Azure SQL Managed Database.

--query-examples

Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.