Wednesday, August 01, 2012 6:31 AM
i am having .dmp file format back up. how to restore it in sql server, plz help me
- Changed Type Naomi NMicrosoft Community Contributor, Moderator Wednesday, August 01, 2012 2:26 PM Question rather than discussion
Wednesday, August 01, 2012 6:51 AMAnswerer
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.
Wednesday, August 01, 2012 7:08 AM
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
Wednesday, August 01, 2012 7:23 AM
my file extension is .dmp. where to change this ?
please help me out.
Wednesday, August 01, 2012 7:24 AMAnswerer
Wednesday, August 01, 2012 2:20 PMA 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.
Thursday, August 02, 2012 8:06 AMModerator
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.
Friday, August 03, 2012 1:36 PM
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.
Friday, August 03, 2012 8:39 PMThe 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.