Migration fails on Windows server: Dump contains more than one database files

Symptoms

Migration fails with the following error in Plesk UI:

stdout: Unable to restore database
Unable to restore the Microsoft SQL database: Dump contains more than one database files

Cause

This is a Plesk Migrator bug with ID PMT-3892 which is planned to be fixed in future Plesk updates.

MS SQL database consists of several database .mdf files.

Resolution

1. Log in to Plesk on the target server.

2. Open migration session in Tools & Settings > Migration & Transfer Manager.

3. Migrate affected subscriptions without database data: switch to List of subscriptions tab > select needed subscriptions > uncheck Migrate database data option > Migrate:

   

4. Copy databases from the source to the target server manually using MS SQL native tools, e.g., SQL Server Management Studio.