Configuring longer backup retention for a Synapse SQL database

By default, backups of a Synapse SQL dedicated pool database are only available for 7 days. In other words, you can retrieve versions of the database that are no older than 7 days. Having a backup retention period of 7 days in most environments will not be sufficient. Therefore, in this recipe, we will learn how to retain backups with a retention period longer than 7 days.

Getting ready

Create a Synapse Analytics workspace, as explained in the Provisioning an Azure Synapse Analytics workspace recipe of Chapter 8, Processing Data Using Azure Synapse Analytics.

Create a Synapse dedicated SQL pool named packtadesqlpool, as described in steps 1 to 3 of the How to do it… section of the Loading data into a dedicated SQL pool using PolyBase and T-SQL recipe of Chapter 10, Building the Serving Layer in Azure Synapse SQL Pool.

Create an Azure Automation account named azadeautomation, as described in steps...