Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

5 Answers 5

up vote 9 down vote accepted

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

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

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

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 :) ;)

share|improve this answer
2  
Depending on the amount of data, that script could be enormous... –  Thomas Rushton May 19 '13 at 15:39
1  
@ThomasRushton That script is by definition going to be bigger than the database itself, probably by at least double if not worse! I hope it's not a 50 GB database... –  ErikE Oct 11 '13 at 0:19

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.