Issue Error 22 importing MSSQL bak file

[SimonHolman]

I have setup a server to test Plesk, and added the local MSSQL server. I can happily create databases and users, but when I try to do "Import Dump" and select my .bak file (or my .zip containing the .bak file) I get the error " Unable to restore the Microsoft SQL database: Dump contains more than one database files " and " (Error code 22) "
The backup file was manually created from another SQL server and it has been verified and confirmed that it only contains a single backup from a single database.

 

[IgorG]

Looks like it is related to Plesk bug PMT-3892 which will be fixed in future Plesk updates.
Now you can try to use MS SQL native tools, e.g SQL Server Management Studio.

 

[SimonHolman]

Is there anywhere I can see the info for this plesk bug?

 

[IgorG]

Is there anywhere I can see the info for this plesk bug?

Details of Plesk bugs are only in internal bugrtacker. You can check that bug is fixed in Change Log for Plesk Obsidian

 

[SimonHolman]

Is there any ETA on this? I don't imagine that the database users will have the required permissions to be able to restore databases via SSMS and this is not something we want to have to do continually on their behalf.

We were about to start provisioning 10 - 15 Windows Plesk servers but this is a deal breaker. The first task will be for our users to migrate hundreds of sites and databases. Without this feature, they can't.

 

[nipivm]

I am facing the same issue. I have a backup file from 2012 server and now trying to restore in Plesk on 2014 server and it is throwing error "
Unable to restore the Microsoft SQL database: Dump contains more than one database files
(Error code 22)"

I can restore the same database in my local 2012 server.
Please help.