-2

is there any way to backup the database say 'ABC' and then restoring with the name 'ABC_Old' on Azure SQL Data Warehouse?

Any help is appreciated. Thanks!

Iam_NC
  • 45
  • 6
  • If you are going to downvote me, please give me a reason why you are doing it. It will give me constructive criticism which will allow me to better frame questions in the future. – Iam_NC Jan 08 '18 at 19:20
  • Don't know about the downvotes, but the closure votes are for being Too Broad. – Dan Bracuk Jan 08 '18 at 19:57

1 Answers1

0

Have you tried adding a new SQL Data Warehouse via the portal, then selecting Backup as the source then configuring the backup options?

Azure portal

See here for info on the restore operation generally:

https://learn.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-restore-database-portal

wBob
  • 13,710
  • 3
  • 20
  • 37
  • I followed steps from the link given, but getting this error: **Restoring SQL database failed in resource group <>** – Iam_NC Jan 08 '18 at 22:08
  • Are you giving the database a different name? Have you tried creating in a different filegroup? – wBob Jan 08 '18 at 22:14
  • I followed the link you provided. And yes, I am renaming the DB name to the 'ABC_Old' and performing a point in time restore. – Iam_NC Jan 08 '18 at 22:26
  • Different resource group? Consider contacting support via the portal if that doesn't work. – wBob Jan 08 '18 at 22:38
  • Resource group is the same. – Iam_NC Jan 08 '18 at 22:57
  • *Solved*. Found out that I did not had the sufficient permission for the resource group. – Iam_NC Jan 09 '18 at 00:23