Can I move a SQL database from MS SQL 2008 r2 web edition to MS SQL Express Edition?

[Luca]

I have a dedicated server running MS SQL 2008 r2 for my business website.
I want to set up a backup system in a lesser spec environment that have MSSQL Express.
I keep trying backing up the 2008 r2 databases and returning them on SQL Express, but get various errors. It would be great if someone help me out to resolve these errors.

[ELI]

what are the errors?

[Luca]

I am getting the following error:

"Specified cast is not valid"

The SQL version creating the backup is 11.0.5343.

The SQL version I am restoring on to is 10.50.4042

[ELI]

The problem is you can't go back to a previous version and your SQL server where you have to return it must be at minimum 11.0.5343 but that can’t be a problem as SQL Express is free thus go and download SQL 2012 express I think it should work for you.

Here are the build/version numbers association
https://buildnumbers.wordpress.com/sqlserver/

sql 2012 express dwonload link and put SP2 on the top - that will be sufficient to acquire the databases restored
https://www.microsoft.com/en-ca/down....aspx?id=29062

[Luca]

Thanks, I'll try this one