Azure Managed Instance Database Recovery

Question

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

Answer 1

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.

Answer 2

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