How to import MSSQL database dump from Plesk into local MS SQL server?

Question

I have a plesk acount and an MS SQL database from wich I got a dump through this interface they provide:

So I downloaded the dump file but it does not come as a .txt file but it comes without any extension and when I try to import it in my local MS SQL Server it fails always.

And when I try to open the dump file with notepad it shows weird characters(see picture below).

What am I doing wrong ?

Answer 1

I got it to work by extracting the dump file from the zip and renaming it with a .bak extension. Then did a Database restore in MS SQL Management Studio and selected this backup file (.bak). Hope that helps.