I have an old SQL 7 DB .bak file I am trying to work with now. I tried to restore the backup in SQL 2008, but it said that it was unable to work with the file. Does anyone know how I could restore this DB?
A:
The database you are attempting to restore to is probably set with version 8 compatibility, not 7. That would be the first thing I would check.
Gregory A Beamer
2009-03-12 17:56:12
This DB was created about 5 years ago. I only have the .bak of the file at this point.
Noah
2009-03-12 19:47:13
+2
A:
You will need to install SQL Server 7, 2000, or 2005 and restore the backup to one of those first.
- SQL 2000/2005 - Restore the backup, export, and restore to 2008.
- SQL 7 - Restore the backup and use the SQL Server 2008 import functionality to import the data.
Chris Pebble
2009-03-12 17:58:00