Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
303 questions
Azure Managed Instance Migration offline mode. Cannot find full back up error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hossain, Shakir
21
Reputation points
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an error -'full backup cannot be found'. I have all the backups saved in seperate folders under one storage container as requirement on the data studio. How to troubleshoot this issue.
{count} votes
-
Oury Ba-MSFT 18,696 Reputation points Microsoft Employee2024-08-02T22:06:10.2166667+00:00 @Hossain, Shakir Thank you for reaching out.
Could you please check if the storage account is located in the same region as the azure database migration service.
Ensure that the service account running the source SQL Server instance has read and write permissions on the SMB network share that contains database backup files.
If you use Database Migration Service for the first time, make sure that
Microsoft.DataMigrationresource provider is registered in your subscription. Follow the steps to register the resource provider.Please check this doc https://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/database-migration-service?toc=%2Fazure%2Fdms%2Ftoc.json&tabs=offline-with-extension to make sure you have met all the prerequisites.
https://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/guide#azure-data-studio
-
Oury Ba-MSFT 18,696 Reputation points Microsoft Employee
2024-08-06T17:12:19.6766667+00:00 @Hossain, Shakir We haven't not heard back from you since my last comment. Could you please share the status of th issue.
Regards,
Oury
-
Hossain, Shakir 21 Reputation points
2024-08-06T19:50:52.5066667+00:00 Hi Oury, thanks for reaching out
Yes, the Storage account and database migration service are in the same region (Canada Central)
Microsoft.DataMigration is registered under the subscription
I am using the offline mode for the migration so should not require any SMB network share, all my backups are in the storage account
Sign in to comment
Sign in to answer