Azure Managed Instance Database Recovery

Rich Vieira 41 Reputation points
2023-01-24T17:18:55.2733333+00:00

Hello,

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
    2023-01-24T18:55:45.11+00:00

    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.

    [https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql&tabs=azure-portal

    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
    2023-01-25T20:16:09.82+00:00

    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