Restoring a .DMP file in SQL

I have a .DMP file that I need to restore to a new SQL database. I tried doing it through mssq2.mydomain.net/mssql, but it errored out after about 20 minutes. The .DMP file is quite large.

What is the best way to restore a .DMP file?

Thanks.
 
DMP files are normally crash dumps, that won't be restored.

BAK files are the typical MS SQL backup binary dump format.

If it is a human readable SQL TEXt query file, you could just use the SQL Management studio remote and import it directly in the Query window.
 
It was a backup created from sql manager, it was not from a crash dump. I'll see if I can get another backup, but if not, is there something that can be done with this .DMP file?

it is too large to open to see if it is human readable (891,729 KB)
 
I would recommend rar/ziping it and FTP uploading it to your domain then support team can pick it up.
 
Stephen -

I zipped the file and FTP'd it up to the server. I put in a support ticket and it's been over an hour with no response. Can you look into an ETA, I kind of need this DB restored so that I can pull data from it ASAP.

Ticket: MNS-84743-762

Thanks

Carol
 
Back
Top