Azure sql database restore

Michael Stoler 290 Reputation points
2023-12-01T20:47:50.54+00:00

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

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,068 questions
0 comments No comments
{count} votes

Accepted answer
  1. Rahul Randive 9,176 Reputation points Microsoft Employee
    2023-12-02T00:53:18.71+00:00

    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!

    0 comments No comments

0 additional answers

Sort by: Most helpful