Azure Managed Instance Database Recovery

Rich Vieira 41 Reputation points


I have a database in my Azure SQL Managed Instance. I want to confirm before I do this that I can restore my DB to a new DB and it will not interfere with the Live DB. I am looking to bring up a test Database of the Production one with the latest Data. Reading the documentation it sound like this is how it would work and if I really needed to recover the production I would just delete the Production Database and rename the Restored.

Disregard figured all out

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Luke Murray 10,276 Reputation points MVP

    When you restore a database, it will create a new database - i.e. database1 will become database2.

    Your correct to overwrite a database, you would have to delete the production database (i.e. database1) and rename the database2.


    You can always stand up a test SQL Managed Instance for a few hours as a test.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Oury Ba-MSFT 15,196 Reputation points Microsoft Employee

    Hi @Rich Vieira Thank you for reaching out.

    My understanding is that you are asking if you restore your DB to a new DB, it will not interfere with the live DB. In addition to @Luke Murray 's answer Restores like point in Time Restore will use backups and will not impact the source Database. see more at Restore a database from a backup in Azure SQL Managed Instance.

    Regards, Oury

    0 comments No comments