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)??