- Plesk for Windows
Cannot import MS SQL dump:
PLESK_ERROR: Unable to import the new_db dump:
Unable to restore database 'new_db'
Not valid backup:
The media family on device 'C:\Program Files (x86)\Plesk\PrivateTemp\db-C1AC.tmp' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally.
(Error code 22)
.sql file extension is used for dumps of MySQL databases, and not of MS SQL. Most probably, such
.sql file which is used for backup restoration is not a backup of the database, but the script that creates the database.
Since Plesk cannot parse database dumps created not via Plesk, the following can be done:
- Make sure that there is no database in MS SQL management studio with the required name;
- Create MS SQL database via Plesk UI:
Domains > example.com > Databases > Add Database
- Open the
.sqlscript file in MS SQL management studio;
- Execute the script: