Backing up and DR in Azure Synapse
There are several aspects that you need to consider when you are planning backup and DR in your Azure Synapse workspace. You'll need to take care of three main areas:
- Data
- Developed artifacts
- Infrastructure setup
Backing up data
You will first look after your data and take care that you don't lose your biggest assets here. The two areas that you want to consider could be the following:
- Storage accounts/data lakes
- Dedicated SQL pools
As the serverless SQL pools and Spark pools are talking to the data lake, mainly you will cover those by backing up the data lake.
Backing up storage accounts/data lakes
A data lake/storage account can be prepared for DR in different ways. There are the following:
- Automated redundancy built into the service. You have already learned about this in Chapter 3, Understanding the Data Lake Storage Layer. You can decide on the zone or geo-redundant storage...