How to restore Azure SQL database without losing backup history

Question

We would like to be able to restore an Azure SQL database to the same name. This isn't possible and the best we can do is to restore to a new name, delete the old, and then rename the new database to what the old one was originally called.

But in doing so we lose all the backup history of the original database.

How can we retain the backup history? Or is this a showstopper that forces us to use managed instance?

thanks

Josh

Answer 1

Somebody made the same question 3 years ago in Stackoverflow as you can see here My answer for you is the same. Unfortunately, restoring from a backup in Azure SQL Database always creates a new database. The secret here is to rename the newly restored database with the name of the original database. You will even see that the restored database once renamed it then shows all the security recommendations, automatic tuning recommendations of the original database.

So, delete existing database, restore the database, and rename it as the original database and all the backup history will be preserved.

Answer 2

So, delete existing database, restore the database, and rename it as the original database and all the backup history will be preserved.

EDIT: Ah yes, i see this will work for us, albeit that the backup history is only retained in the deleted datbase - which is fine

Thanks