37

When trying to restore a backup to a SQL Server Express 2008 database I got the following error:

Restore failed for Server '...\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: The database was backed up on a server running version
10.50.1600. 
That version is incompatible with this server, which is running version 10.00.2531. 
Either restore the database on a server that supports the backup, or use a backup 
that is compatible with this server. (Microsoft.SqlServer.Smo)

Is there a way to get a backup which is compatible with the older (in my case 10.00.2531) version from the newer (in my case 10.50.1600) version of SQL Server Express?

rem
  • 1,555
  • 3
  • 20
  • 22

5 Answers5

21

You'd have use the Import/Export wizards in SSMS to migrate everything

There is no "downgrade" possible using backup/restore or detach/attach

gbn
  • 70,237
  • 8
  • 167
  • 244
12

You can use the Import/Export wizard to move data between databases.

Right click on the database you want to export, choose "Tasks", then "Export Data". The wizard will guide you through the process.

You're right, though. You won't be able to do a backup/restore moving from SQL Server 2008 R2 to SQL Server 2008 Express.

Richard
  • 1
  • 8
  • 42
  • 62
8

SQL Server backup doesn't support backward compatibility

Steps to get DB on older versions -

  • For Schema: right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "schema" -->ok -->next -->next

  • For Data: right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "data" -->ok -->next -->next

dsingh
  • 320
  • 3
  • 4
6

The only way is to create a new database on the 10.00.2531 version and import the data from 10.50.1600.

You can't restore down to an older version.

SQLRockstar
  • 6,355
  • 27
  • 48
5

right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "schema and data" -->ok -->next -->next so now you have a script that creates database and its table and fills the data in it :) ;)

Sarah
  • 51
  • 1
  • 1