Failed to import an SQL Server backup file during website migration-阿里云帮助中心

Importing an SQL Server backup file might fail during website migration in the host management console. This failure can occur if the backup file is corrupted or has an incorrect format. This topic describes the possible causes of this issue and provides solutions.

Symptoms

When you migrate a website in the host management console, you select the SQL Server backup file to import and the destination database. After you click Next, the system displays the following error:

After you click OK, the message Data import failed appears during the database migration, as shown in the following figure:

Database migration failed

Possible causes

The SQL Server backup file is corrupted or has an incorrect format.

The database migration feature supports only SQL Server backup files with the .bak extension. Backup files that have other extensions cannot be detected.

Solutions

Repair the SQL Server backup file.
- If the SQL Server backup file is provided by your host service provider, contact the provider for a solution.
- If you prepared the SQL Server backup file yourself, check and repair the file.
  1. Find the SQL Server backup file to import, right-click the backup file, and select Rename.
  2. Add the .bak extension to the backup file name.
    For example, if the original file name is studb, change it to studb.bak.
Migrate the website again to verify that the issue is resolved.
If the issue persists, submit a ticket.