restore sql server dump backupfile

Question

User-1687766116 posted

hi,

I have sql server backup DUMP file from plesk panel.

in sql server managment studio this file not restored. how i do?

Answer 1

User753101303 posted

Hi,

This is a backup file? You could use SQL Server Management Studio or the Transact SQL "RESTORE" statement to restore this db. If you tried and it fails which error do you have.

Are you sure your hosting service or Plesk doesn't give any indication about the file created by this "dump" function (for now I assume it is produced by the BACKUP statement).

For details try https://msdn.microsoft.com/en-us/library/ms187048.aspx and scroll down to "restore data backups". It migght be a bit longer to create a script but the benefit is that you'll be able to run the script again and again without having to go through UI options each time.

Answer 2

User932909087 posted

Hi mehr_83,

This is .bak file or not? Or you can ask your hosting provider to give you .bak file so you can restore it on your local PC.