We got a database hosted on Azure SQL Managed Instance.
Got an application change planned soon and as part of implementation plan, we need to manually take a backup of database on Azure SQL Managed Instance at the beginning of the change and restore it (overwrite existing DB) if there is a rollback. What's the best way to achieve this ?
My best suggestion for you is to copy the database before applying the change, and if you need to rollback just rename the database copy.
ALTER DATABASE [YourDB] MODIFY NAME = [YourDB_PostChange];
ALTER DATABASE [YourDB_PreChange] MODIFY NAME = [YourDB];
Another option is to perform Backup to URL prior the change, in case you need to rollback you will need to rename or drop the database, then restore from BLOB storage account.
