User Defined Retention Periods for Restore Points (snapshots)
Currently SQL DW doesn't have the capability to specify longer term retention capabilities as released for SQL DB recently. It would be great to have this capability for compliance and auditing requirements.
Thank you for your patience. This is currently on our road map. Please continue voting for this feature and comment on your scenario below. We’ll reach out when the feature is available to everyone who voted.
Veerendra Thati commented
This is a much requested feature by one of our important customer
Tarun Arora commented
Here is the blogpost I allued to in my previous comment - https://blogs.msdn.microsoft.com/sqlcat/2016/12/20/azure-sql-dw-moving-to-a-different-region-with-restore-from-backup-option/
Tarun Arora commented
The blogpost from your collegues in Azure CAT implies that it's possible to restore SQL DW betwen Azure subscriptions. Which is wrong as it does not work the way the blob projects it does. Can I confirm that SQL DW restore across subscriptions isn't supported today and that this request currently being reviewed will likely enable this functionality?
Henrik Kure commented
We also have a customer who needs better control over backups (more than 7 days and manual control).
We are using 2 logical sets of SQL DWs with 2 SQL DW in each set. We loaded data in to one logical set in production. We want to take the 2nd logical set also to production and need to take back up of the 1st SQL DW and apply on the 2nd logical set of SQL DW. We need a quiet database backup so that the data is in sync in backup copy. We need the ability to request a back up. At this point, we have to stop production for 12-16 hours. The Production is 24X7 for us.
My customers want to have a quiesce point of backup.
Manual backup is required.
They also want to check the cost of the backup.
Anagha Khanolkar commented
+1 for user-initiated backup. This is a feature of interest for my customers.
Hi Greg, LTR and user initiated backup complement each other but also have distinct use cases. Would you kindly create a new suggestion specifically for LTR so we can track that? Thanks.
Greg Galloway commented
There was a recent announcement of the Azure SQL Database Long-Term Retention feature. Maybe adding SQL DW support to that feature would accomplish this request?
The current approach long term backup by restoring as a new DW that stays paused was a good idea until the premium storage switch. Now it's too expensive.
Ralph Kemperdick commented
This is an essential option to keep data over a long period of time offline.