Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.

You need to design a backup solution for Azure SQL Database that will store backups that can be restored for up to 5 years. What solution will you recommend?

Experience Level: Senior
Tags: Azure CloudAzure SQL Database

Answer

Use Azure SQL long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years.
You can then recover a database using these backups using the Azure portal or PowerShell. Long-term retention policies are also supported for Azure SQL Managed Instance.
Related Azure Cloud job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
Azure SQL Database
Azure SQL Database

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself