Desktop

Ask something
Discussion Locked

Recovering a SQL Server 6.5 database

0 helpful
1 reply

by lwilson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I recently took down a SQL Server 6.5 installation. Afterwards, I found I had failed to upgrade one of the databases. I have the .dat and the .log files for that database. How do I get SQL 7 or 2000 to attach to that database?

1 reply

by rapidad

I doubt the 6.5 data files are compatible with 7.0 or higher as Microsoft made a major change in the way data was stored between 6.5 and 7.0. There is an outside possibility that it you have logs for all the data, that you could apply them to a 7.0 or higher database, but I don't know.

Probably your best bet is to reinstall 6.5, figure out how to attach the database files to it, and then use the Migration Wizard to migrate the data to a 7.0 or higher database

This discussion is closed to new replies.