Link to home
Create AccountLog in
Avatar of Richard Lloyd
Richard Lloyd

asked on

Can I restore or move a SQL database from MS SQL 2008 r2 web edition to MS SQL Express edition

Hi.

I have a dedicated server running MS SQL 2008 r2 for my web hosting business.

I'd like to set up a backup system on a lower spec (cheaper) environment that uses MSSQL Express.

I have tried backing up the 2008 r2 databases and restoring them on SQL Express, but get various errors.

Can anyone let me know if what I am trying to do is possible before I try to tackle all the errors.

Thanks!
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

is your MSSQL Express also 2008 r2 (or better)? Are you using features not supported by the Express edition?

What are the errors?
"I have tried backing up the 2008 r2 databases and restoring them on SQL Express, but get various errors."
What exact errors are you getting?
Please check the DIFFs between SQL Server EDITIONS at link below and see wich ones can lead to the errors (like DB size maybe?)

https://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx
Avatar of Richard Lloyd
Richard Lloyd

ASKER

I get 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
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks . I'll give this a try and see how I get on.