how to restore .dmp file in sql server

Question

i am having .dmp file format back up. how to restore it in sql server, plz help me

Answer 1

Hello,

Do you have a real dump file as an result of an exception? This one you can't restore to SQL Server.

Or is it a real SQL Server backup file, which is only named with extension .dmp? Then simply restore the backup, the extension doesn't matter. In file open dialog change the filter from *.bck to *.*, then you can select the file.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

did you use any other third party tool to make that backup file

or else it is generated from the SQL Server itself,

if it is generated from  SQL Server as  a Backup File then this can be restored in the

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 3

mr.olaf

my file extension is .dmp.  where to change this ?

please help me out.

Answer 4

Try

RESTORE DATABASE dbname  FROM DISK='C:\file_name.dmp'

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 5

A file extension doesn't say us anything about what format that file is of. You have to ask those who produced this file what type the file is and/or how the file was produced.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 6

Hi selvakumars,

Do you have software which named iBackup on your computer? The .dmp is proprietary to iBackup and cannot be read by SQL Server which only understands its own backup files (.bak).

If you want to restore it, you need to restore through iBackup software. For more details, please refer to this thread.

Best Regards,
Ray Chen

Answer 7

SQL Server can create backup files without even giving extension or giving any extension, its independent of extension with restoration as well.

if its a valid backup file [native backup] it will work flawlessly.

Answer 8

The default extension of Sybase SQL Server backups is ".dmp", but, as several people have pointed out, MS SQL Server (and also Sybase SQL Server) can create backups with any extension. Just try loading the backup, as Uri Dimant suggest. Come back and tell us if you succeeded or not. If it is a Sybase dump file (there terminology for backup), you can load it in a Sybase server and use the SSMA tool to migrate your code and your data. Be aware, however, that is not something you just do on a Friday afternoon.