Link to home
Start Free TrialLog in
Avatar of Steve Jebson
Steve JebsonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Backup/Retore from 10.50.1617 to 10.00.1600

Hi,

I'm using SQL Server 2008 R2 developer edition and i want to back up and restore to a SQL Server 2008 R2 Express however when i try and restore to the Express i get an error saying restore backup failure 10.50.1617 to 10.00.1600.

Is there another way i can get the db onto the lower version without having to upgrade the sql express installation ??

thanks
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
10.00.1600 is SQL 2008 NOT R2.  You cannot restore from a higher version to a lower version.
hi

you can try to change the compatibility mode of the database to a lower ver and then backup$restore.

worth the try.
>you can try to change the compatibility mode of the database to a lower ver and then backup$restore.

still it wont work, the compatability option is for supporting the previous versions of TSQL, the  database engine will remain the same even if you change the compatability level.
>still it wont work, the compatability option is for supporting the previous versions of TSQL, the  database engine will remain the same even if you change the compatability level.

well then its back to just export import.
Avatar of Steve Jebson

ASKER

thanks for quick responses, looks like i'll have to try the scripts to export n import....
ok, managed to do it via...

Tasks / Generate Scripts
You need to set the "Type of data to script" to Schema and Data as the default is Schema. This is in the Set Scriptin options / Advanced section

I then just stripped out the creation of the db and the stored procedures in notepad

Very simple in the end, isn't it always when you find the answer !