Azure SQL Managed Instance - How does the new database created in the portal reference the restored database from on-prem?

[Scott Evans_470]

Hi All, I`m in the process of migrating SQL databases from on-premise to Azure SQL Managed instance. I have followed the "back up and restore" outlined here "SQL Server to Azure SQL Managed Instance: Migration guide". I have started with a test db, created a new managed instance database and restored the db from the storage account URL and I can see the storage utilisation has noted the size of the imported db and all tests are good in regards to the SQL db and application. How does the manually created managed instance database reference the copied database from

Continue reading...