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

Symptoms

• Migration fails with the following error in Plesk UI:

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

• Same errors in %plesk_dir%\var\modules\panel-migrator\logs\debug.log:

  CONFIG_TEXT: |I|MT|core.reports.printer|||| stdout: Unable to restore database 'purerealtors'
  |I|MT|core.reports.printer|||| Unable to restore the Microsoft SQL database: Dump contains more than one database files
  

Cause

This is 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 into 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.