How to Retore a dmp File

[Steve101]

One of my clients has a web site which incorporates a backend SQL Server database. Right now, I dont know too many details of the SQL environment (ie. could be 6.5, 7, 2000).

At any rate, I asked them if they could get a copy of a database to me, so that I could inspect it.

They've come back to me with a CD which contains the whole site, including a large file with a .dmp file extention, which I assume is some sort of dump / backup of the database.

I had a quick attempt last night at restoring this file via enterprise manager into an MSDE environment on my workstation, but the restore did'nt seem to be able to recognise this file.

A DBA colleague of mine has mentioned in passing that the file could be from SQL Server 6.5, which may not be able to be recognised as a valid database from within my Enterprise Manager / MSDE 2000 environment.

I'm quite keen to restore this file (preferably without going back to the provider). What are my best options.

Any advise would be appreciated,



Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Steve101]

OK. Have checked the SQL 7 documentation on the above, which would seem to confirm that its a version 6.5 backup.

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[chrislarkin]

Do you have the ability to speak with your client about the files?

 

[Steve101]

Would prefer not to have to bother the client Chris, so what we'll do is find a site with a SQL 6.5 setup, load the dmp file that way, save the schematic, csv type format, and reload that way.

Cheers,


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)