0

I have a database in azure bucket (.bak) that comes daily from another system and I want to create a stored procedure to restore a database.

I have seen many guides about the command BACKUP RESTORE... but I get the error:

Statement 'RESTORE DATABASE' is not supported in this version of SQL Server.

I have no idea how to proceed... how can I restore this backup in a azue db (or also in a vm with SQL server)??

Improve this question
2
  • Do you know what database system the backup comes from?...that'll dictate your options. Azure SQL Database is not the same as SQL Server (similar to MongoDB not being the same as MySQL), and the ability to restore backups between the two are limited (if even possible).
    – J.D.
    Mar 24 at 19:42
  • The only RESTORE command syntax available on the managed instance is "RESTORE DATABASE ... FROM URL". Did you try to use that particular syntax of RESTORE DATABASE command? Syntax
    – Denis Rubashkin
    Mar 27 at 7:49

1 Answer 1

Reset to default
0

Before you have to download the DMA Tool and check if that database is compatible with Azure SQL Database.

Run the DMA Tool against the SQL Server on prem.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.