Question How to import a previous Export Dump into a local SQL instance?

[Carneno]

Hello,

I'm using Plesk for Windows 12.5.30 and Microsoft SQL.

After I use the "Export Dump" for my SQL database in Plesk, it creates a ".zip" file named "autoima1_AutoImages_2018-04-06_10-34-43.zip". If I unzip the file, it gives a file with the same name, but without an extension.

How can I use that file to import it into my local Windows 10 computer SQL 2016 server instance?

Any help would be gratefully appreciated.

Thanks,
Tony

 

[MarkM]

I’m not a windows guy, but if you open the extracted file in notepad or the like does it look like a normal sql backup? You may be able to just rename it and add the SQL extension.

 

[Carneno]

I’m not a windows guy, but if you open the extracted file in notepad or the like does it look like a normal sql backup? You may be able to just rename it and add the SQL extension.

Mark,

Thanks for your help.

That was all I needed to do. Renaming it to a ".bak" file allowed me to restore it from a backup.

Thanks,
Tony