Geek Answers Handbook

Is it possible to restore SQL 7 DB to SQL 2008?

I have an old SQL 7. DB database file that I'm trying to work with now. I tried to restore the backup in SQL 2008, but he said that he could not work with the file. Does anyone know how I can restore this database?

+4
source share
2 answers

You will need to install SQL Server 7, 2000 or 2005 and restore the backup to one of them.

  • SQL 2000/2005 - Restore backup, export and restore before 2008.
  • SQL 7 - Restore a backup and use the SQL Server 2008 import function to import data.
+4
source

The database you are trying to recover is probably installed with version 8 compatibility, not 7. This would be the first thing I could check.

0
source

More articles:


All Articles