No full backup file present or Database Migration service could not access the file

Nilesh Patel 111

I am migrating my on-premise SQL server to Azure SQL MI using Azure DMS. I have provided the full database backup to my SMB network share path. I have successfully created Azure Database Migration Project under Azure Database migration Service, during the last phase of the project I am getting validation error.

Error detail: No valid full backup found for database 'DBNAME'. Either there was no full backup file present or Database Migration service could not access the file.

I don't know where I made mistake can anyone please guide me on this.

Thanks,
Nilesh

GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-08T16:49:30.817+00:00

Hi, @Nilesh Patel Thanks for posting your query in the Microsoft forum.

I Understand that you are trying to migrate an on-premise SQL Server to Azure SQL MI using DMS and you have also provided a full DB backup. correct me if my understanding is not accurate.

You mentioned that during the last phase of the project, is that mean at step 7 you got this error?

Regards
Geetha
Santhamoorthy M 161 Reputation points

2022-02-08T17:24:51.353+00:00

@GeethaThatipatri-MSFT we are using DMS online migration (Not Azure Data Studio with DMS) and in configuration setting we entered the db backup location but its giving us the above error. Attaching screenshot where we are entering all the details.
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-08T20:07:46.843+00:00

Thanks, @Santhamoorthy M for sharing the screenshot,
Hi, @Nilesh Patel did you mention the full backup path or followed \servername.domainname.com\backupfolder as mentioned?

Please try using as below if it might help you to fix the location path.

Regards
Geetha
Santhamoorthy M 161 Reputation points

2022-02-09T04:03:54.657+00:00

@GeethaThatipatri-MSFT yes we provided the share location without backup file name only and still its giving same error. Could you pls advise if any other configuration we have to check or missed.

Thank you!
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-09T15:39:02.41+00:00

Sure @Santhamoorthy M I will look into it, can you please confirm if you have followed the prerequisite steps listed here Tutorial: Migrate SQL Server online to SQL Managed Instance - Azure Database Migration Service | Microsoft Learn, especially around setting up the required permissions.

Regards
Geetha
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-10T01:52:07.56+00:00

Hi, @Santhamoorthy M I am checking with the internal product team to provide you with more details on the issue.

Regards
Geetha

1 answer

GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-10T19:31:46.45+00:00
Hi, @Nilesh Patel I did some research and found the below configuration settings for SMB share, prerequisites, and known issues if it might help you to fix the issue.

Configure Migration settings.

Prerequisites

SMB file share connectivity
there is a full backup for source SQL DB on the shared file system (SMB Share)
The credentials used to copy the backup file to or from the file share to the target system should have read/write permission to access the file share.

Verify you can do restore header only RESTORE HEADERONLY FROM DISK = N'\<SMB file share path>\full.bak'
Note:- the time of restore headeronly shouldn't be long (less than 10minutes) and the output should match the selected source database name with the DatabaseName in RESTORE HEADERONLY.

In case The RESTORE HEADERONLY query is taking over 10 mins. the workaround is to use the compressed option and stripe backup into 8/10 files for the backup.

Regards
Geetha
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-14T15:49:55.25+00:00

Hi, @Nilesh Patel We haven't heard back from you. Just wanted to check if you are still facing the issue?

Regards
Geetha

GeethaThatipatri-MSFT 29,482 Reputation points Microsoft Employee

2022-02-16T14:53:14.977+00:00

Hi, @Nilesh Patel We haven't heard back from you. Just wanted to check if you are still facing the issue?

Regards
Geetha

Seshagiri Rao Vadrevu 101 Reputation points

2023-05-24T05:55:09.9933333+00:00

im trying to migrate from azure vm to azure managed instance where im having the same issue. it is not detecting the backup file but i do have another problem. where i dont have shared file storage in azure vm. while trying to select a local hard drive with shared access im getting error
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

No full backup file present or Database Migration service could not access the file

1 answer

Your answer