long_term_retention_managed_instance_backups

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

Overview

Name	long_term_retention_managed_instance_backups
Type	Resource
Id	azure.sql.long_term_retention_managed_instance_backups

Fields

vw_long_term_retention_managed_instance_backups

Name	Datatype	Description
backupName	text	field from the properties object
backup_expiration_time	text	field from the properties object
backup_storage_redundancy	text	field from the properties object
backup_time	text	field from the properties object
databaseName	text	field from the properties object
database_deletion_time	text	field from the properties object
database_name	text	field from the properties object
locationName	text	field from the properties object
managedInstanceName	text	field from the properties object
managed_instance_create_time	text	field from the properties object
managed_instance_name	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

long_term_retention_managed_instance_backups

Name	Datatype	Description
properties	object	Properties of a long term retention backup

Methods

Name	Accessible by	Required Params	Description
get	SELECT	backupName, databaseName, locationName, managedInstanceName, subscriptionId	Gets a long term retention backup for a managed database.
get_by_resource_group	SELECT	backupName, databaseName, locationName, managedInstanceName, resourceGroupName, subscriptionId	Gets a long term retention backup for a managed database.
list_by_database	SELECT	databaseName, locationName, managedInstanceName, subscriptionId	Lists all long term retention backups for a managed database.
list_by_location	SELECT	locationName, subscriptionId	Lists the long term retention backups for managed databases in a given location.
list_by_resource_group_database	SELECT	databaseName, locationName, managedInstanceName, resourceGroupName, subscriptionId	Lists all long term retention backups for a managed database.
list_by_resource_group_location	SELECT	locationName, resourceGroupName, subscriptionId	Lists the long term retention backups for managed databases in a given location.
delete	DELETE	backupName, databaseName, locationName, managedInstanceName, subscriptionId	Deletes a long term retention backup.
delete_by_resource_group	DELETE	backupName, databaseName, locationName, managedInstanceName, resourceGroupName, subscriptionId	Deletes a long term retention backup.

SELECT examples

Lists the long term retention backups for managed databases in a given location.

vw_long_term_retention_managed_instance_backups

SELECT
backupName,
backup_expiration_time,
backup_storage_redundancy,
backup_time,
databaseName,
database_deletion_time,
database_name,
locationName,
managedInstanceName,
managed_instance_create_time,
managed_instance_name,
resourceGroupName,
subscriptionId
FROM azure.sql.vw_long_term_retention_managed_instance_backups
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';

long_term_retention_managed_instance_backups

SELECT
properties
FROM azure.sql.long_term_retention_managed_instance_backups
WHERE locationName = '{{ locationName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified long_term_retention_managed_instance_backups resource.

/*+ delete */
DELETE FROM azure.sql.long_term_retention_managed_instance_backups
WHERE backupName = '{{ backupName }}'
AND databaseName = '{{ databaseName }}'
AND locationName = '{{ locationName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';