How to back up and restore the storage account Gen2 of the azure synapse workspace

Phuong Pham 0

Dear Team,

We are using the "Azure synapse workspace" for D365FO. Our user want to back up and restore the data of the Azure synapse workpace. Please show us how to do this.

Smaran Thoomu 16,555 Reputation points Microsoft Vendor

2024-10-23T12:55:14.0266667+00:00

@Phuong Pham Following up to see if the below answer was helpful. 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.

1 answer

Smaran Thoomu 16,555 Reputation points Microsoft Vendor

2024-10-22T14:53:16.8366667+00:00

Hi @Phuong Pham

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Unfortunately, there is no option to ADLS Gen2 Backup and Point-in-time restore.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

For Azure Data Lake Gen2 Data, you can use Enable Soft delete for blobs/containers to restore the deleted data.

Blob soft delete protects an individual blob, snapshot, or version from accidental deletes or overwrites by maintaining the deleted data in the system for a specified period of time. During the retention period, you can restore a soft-deleted object to its state at the time it was deleted. After the retention period has expired, the object is permanently deleted.

Go to the ADLS gen2 storage account, under Data management, select Data Protection and enable Recovery options as shown below:

Now lets try to restore the file which we deleted. Select the file to undelete.

Note: Make sure select the Show deleted objects to show the deleted files.

Hope this will help. Please let us know if 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.
Please sign in to rate this answer.
Smaran Thoomu 16,555 Reputation points Microsoft Vendor

2024-10-24T15:09:09.22+00:00

@Phuong Pham Following up to see if the below answer was helpful. 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.

Phuong Pham 0 Reputation points

2024-10-29T03:13:39.64+00:00

Hi Samaran,

Thank you for your solution. We have two environments, PROD and UAT. When needed, we need to restore a backup from the PROD environment to the UAT environment. Do you have any ideas about this case?

Smaran Thoomu 16,555 Reputation points Microsoft Vendor

2024-10-29T08:58:06.4533333+00:00

@Phuong Pham Thank you for the additional details! For your scenario, where you need to copy or restore data from your PROD environment to UAT, you can consider these approaches:

Using Azure Data Factory (ADF) for Data Copy: You can use ADF to copy data from the ADLS Gen2 storage in the PROD environment to UAT. ADF allows you to set up pipelines to copy data between different environments and can be scheduled or triggered as needed. This approach provides flexibility and control over what data gets copied and when.

Snapshot-Based Data Transfer: While ADLS Gen2 doesn’t have native backup/restore, you could create periodic snapshots of your files in PROD and store them in a separate folder or storage account. When a restore to UAT is needed, you can copy the data from these snapshots.

Custom Scripting with Azure CLI or PowerShell: If you prefer a custom solution, you can use Azure CLI or PowerShell scripts to copy data between the storage accounts in PROD and UAT. This approach is ideal if you have specific requirements or need automated data sync.

Unfortunately, without a native point-in-time restore option for ADLS Gen2, these alternatives can help you achieve a similar result by ensuring your data is available across environments when needed.

Hope this helps. Do let us know if you 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.

Smaran Thoomu 16,555 Reputation points Microsoft Vendor

2024-10-30T13:11:01.6933333+00:00

@Phuong Pham Following up to see if the above answer was helpful. 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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to back up and restore the storage account Gen2 of the azure synapse workspace

1 answer

Your answer