Azure sql database restore

Question

Hello,

In the event that I need to restore an Azure SQL Database I have a few questions:

1. Is it correct that I can only restore to a New Database and not replace the current database.
2. If I can only restore to a new database how can I rename the database back to the old database and still keep the backup history.

Thank You,

Michael

Answer 1

Hi Michael Stoler •

Yes, you are correct, when you restore, it will restore with new name and not replace the current one.

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

Or if you would like to keep original database then

Rename the original database to a new name

Restore the database with old name

Thank you!