SQL 6.5 DAT File Import to SQL 2000/2005

A SQL Server failed that hosted a SQL 6.5 database. We performed a backup of the database using the built in backup tools within SQL 6.5. File is a .DAT file. The orginial MASTER database was corrupted when the server failed and now I cant get the backed up .DAT file to restore to another SQL 6.5 or newer database. Used a demo software, Recovery for SQL Server 3.0, to look at .DAT files data and it was intact, but dont want to spend the $500.00 for the program. What is the best way to attach the .DAT file to a newer SQL instance and export the data?
tosmserversupportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

How badly did the SQL Server 6.5 crash? Can you get any data out? I'd try the SQL Import wizard to extract the data from that mostly functioning SQL 6.5 if possible.

Otherwise attempt to restore the backup file to a new SQL 6.5 install. You might need to apply a service pack to two to get the new installation to the same level as previous installation.

Else use the above program at $500

Or hire a specialist SQL consultant firm to look at the files at a minium of a couple of hours at a significant hourly rate.

I'd suggest that if the demo program has worked, then $500 is cheap everyway you look at it - time, money, stress ...

Cheers
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Guy Hengel [angelIII / a3]Billing EngineerCommented:
when the backup was done using sql 6.5, you can only use sql 6.5 to restore the file.
however, you will need to apply the same service pack that what you had before, with a "bare" sql 6.5 you might indeed get those problems.

what are the errors you get?
0
tosmserversupportAuthor Commented:
When I go through the Restore process on a clean SQL 6.5 instance and try to restore the database from the DAT file I have, which is patched to the same level as before, The button to perform the Restore is grayed out.

I have tried to attach the DAT file as a SUSPECT DB and resetting the status flags but that does not work either.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

David ToddSenior DBACommented:
Hi,

Try using the command-line to restore as another database ... This will a) prove that you can restore the database, b)allow you to use DTS and wizards to upgrade the database to either SQL 2000 or SQL 2005 c) you don't have to overwrite the existing database ...

Cheers
  David
0
tosmserversupportAuthor Commented:
What would be the syntax for the restore to another database.  I am having problems locating syntax on the web, I guess due to age of 6.5...
0
tosmserversupportAuthor Commented:
for the interest of time, we just purchased the software and went on with business.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.