We're working on migrating some SQL Server VMs to Azure SQL Managed Instances. We did an initial backup/restore without a problem:
RESTORE DATABASE [xxx] FROM URL = 'https://<account-name>.blob.core.windows.net/<container-name>/<filename>.bak'
After doing testing, we now need to do a fresh restore from our SQL VMs. We started doing the same process we initially did but when restoring, we got an error:
Msg 1801, Level 16, State 1, Line 1 Database 'xxx' already exists. Choose a different database name. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
So I tried the WITH REPLACE option. Unfortunately:
Msg 41901, Level 16, State 2, Line 1 One or more of the options (replace) are not supported for this statement in SQL Database Managed Instance. Review the documentation for supported options.
Reviewing the documentation just tells me that WITH REPLACE isn't available on a Managed Instance. I can't find any documentation on doing an in-place restore/overwrite of an existing managed instance database.
Am I forced to drop and re-create the database?