question

PradeepKumarGunde-0846 avatar image
0 Votes"
PradeepKumarGunde-0846 asked SumanthMarigowda-MSFT edited

How to backup the Dedicated SQL pool into Azure blob

HI Team,

As Part of Decommission steps we would like to Backup the Sql Dedicated Pool DW into Azure Blob/ Any other File formats, prior to Delete Everything , Can anyone suggest on this taking backup of Sql Dedicated Pool.

azure-synapse-analyticsazure-backup
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @PradeepKumarGunde-0846,

Welcome to the Microsoft Q&A platform.

Unfortunately, you cannot backup the dedicated SQL pool into Azure Blob Storage.

I would suggest you to vote up an idea submitted by another Azure customer.

https://feedback.azure.com/forums/307516-azure-synapse-analytics/suggestions/38983633-export-restore-point-to-blob-storage-for-long-term

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

You can create a new user-defined restore point for a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics by using PowerShell and the Azure portal.

For more details, refer to User-defined restore points for a dedicated SQL pool (formerly SQL DW).

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


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @PradeepKumarGunde-0846,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @PradeepKumarGunde-0846,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·