0

I copied my project to my hosting server space and received the following message while trying to run it:

The database '[path\MDF file] cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.

Any suggestions? I imagine it has to do with me using SQL Server Express 2008 and the hosting provider isn't. If so, where do I go from here? Does SSE have scripts available for re-creating the tables, and in another version?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Febin J S
  • 1,358
  • 3
  • 26
  • 53
  • 1
    Your MDF file is newer than the version of SQL Server that's installed - that "downgrade path" is not supported by SQL Server. If you backup from a SQL Server **2008 R2** version, you can only restore to **2008 R2** (or **newer**) - but not to a **2008** version... – marc_s Jun 07 '12 at 16:04
  • See: [Why a SQL Server database from a higher version cannot be restored onto a lower version](http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html) – marc_s Jun 07 '12 at 16:06
  • possible duplicate of [SQL Server: attach incorrect version 661](http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661) – Matthew Steeples Mar 15 '14 at 20:56

1 Answers1

0

Other than recreating the database from scratch using a SQL 2000 comparability level, I got nothing...

Rawheiser
  • 1,200
  • 8
  • 17