[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2293
  • Last Modified:

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?
0
tosmserversupport
Asked:
tosmserversupport
  • 3
  • 2
1 Solution
 
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
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now