question

KelvinZheng-5004 avatar image
0 Votes"
KelvinZheng-5004 asked AnuragSharma-MSFT answered

Long term reteion backup for Azure SQL managed instance

The built-in backup LTR is up to 10 years. However, the data was required to keep beyond 10 years. What's the best way to overcome the limitation?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

Hi @KelvinZheng-5004 , welcome to Microsoft QnA Forum.

You are right in mentioning that the built-in backup LTR is supported up to 10 years for Azure SQL managed Instance. However we have alternatives to store the backup for longer period through manually uploading the backup on the Azure Blob Storage and defining the retention policies of those blob storage.

  1. Create and upload the backup on blob storage as mentioned in the below article:
    Native database backup in Azure SQL Managed Instance

  2. Define the access tiers for blob storage as mentioned in the article
    Hot - Optimized for storing data that is accessed frequently.
    Cool - Optimized for storing data that is infrequently accessed and stored for at least 30 days.
    Archive - Optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements, on the order of hours.

Based on the requirement we can set these access tiers and have the blob storage available for much longer time. Below is the example to set the blob storage to delete after 7 years from last modification. We can change the policy according to out need:

Optimize costs by automating Azure Blob Storage access tiers

Please let us know if this helps or else we can discuss further.


If answer helps, please mark it as 'Accept Answer'




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.