long_term_retention_managed_instance_backups_by_resource_group_instances

Creates, updates, deletes, gets or lists a long_term_retention_managed_instance_backups_by_resource_group_instances resource.

Overview

Name	long_term_retention_managed_instance_backups_by_resource_group_instances
Type	Resource
Id	azure.sql.long_term_retention_managed_instance_backups_by_resource_group_instances

Fields

The following fields are returned by SELECT queries:

list

Successfully retrieved the list of backups.

Name	Datatype	Description
properties	object	Resource properties.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	resourceGroupName, locationName, managedInstanceName, subscriptionId	onlyLatestPerDatabase, databaseState	Lists the long term retention backups for a given managed instance.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
locationName	string	The location of the database.
managedInstanceName	string	The name of the managed instance.
resourceGroupName	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
subscriptionId	string	The subscription ID that identifies an Azure subscription.
databaseState	string	Whether to query against just live databases, just deleted databases, or all databases.
onlyLatestPerDatabase	boolean	Whether or not to only get the latest backup for each database.

SELECT examples

list

Lists the long term retention backups for a given managed instance.

SELECT
properties
FROM azure.sql.long_term_retention_managed_instance_backups_by_resource_group_instances
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND locationName = '{{ locationName }}' -- required
AND managedInstanceName = '{{ managedInstanceName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND onlyLatestPerDatabase = '{{ onlyLatestPerDatabase }}'
AND databaseState = '{{ databaseState }}'
;