Restore SQL Pool from Restore Point in Different Zone

Question

Can a dedicated SQL pool in Azure Synapse Analytics be restored using a restore point (snapshot) from a different zone when the source zone (where the snapshot was taken) is unavailable due to a region outage?

Reference: Restore from Restore Points

Answer 1

@Taiob Ali - Thanks for the question & using MS Q&A forum.

Azure Synapse Analytics supports geo-redundant backups, which allow you to restore your data warehouse to a different geographical region.

Here's how you can perform a geo-restore:

1. Identify the Source Workspace and SQL Pool:
   • Determine the workspace and SQL pool where the restore point was created.  
   • Ensure that the target workspace is located in a different zone or region.
2. Create a New SQL Pool:
   • In the target workspace, create a new dedicated SQL pool with the same configuration as the original one.
3. Restore from Restore Point:
   • Navigate to the Additional Settings tab during the creation of the new SQL pool.  
   • Select Use Existing Data.
   • Choose the Restore point option.
   • Select the source workspace and the SQL pool you want to restore from.
   • Select the desired restore point.

Note: Ensure that your SQL pool has geo-redundant backup enabled to protect your data in case of regional failures.

For more details refer to this: Backup and restore dedicated SQL pools in Azure Synapse Analytics

Restore an existing dedicated SQL pool

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click `Accept Answer` and `Yes` for was this answer helpful. And, if you have any further query do let us know.