views:

293

answers:

2

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
This DB was created about 5 years ago. I only have the .bak of the file at this point.
Noah
+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

related questions