long_term_retention_managed_instance_backups_by_instances

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

Overview

Name	long_term_retention_managed_instance_backups_by_instances
Type	Resource
Id	azure.sql.long_term_retention_managed_instance_backups_by_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	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.
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_instances
WHERE locationName = '{{ locationName }}' -- required
AND managedInstanceName = '{{ managedInstanceName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND onlyLatestPerDatabase = '{{ onlyLatestPerDatabase }}'
AND databaseState = '{{ databaseState }}'
;