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?

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