Avatar of Steve Jebson
Steve Jebson
Flag 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
Microsoft SQL Server

Avatar of undefined
Last Comment
Steve Jebson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Gary Dewrell

10.00.1600 is SQL 2008 NOT R2.  You cannot restore from a higher version to a lower version.
Aaron Shilo

hi

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

worth the try.
Aneesh

>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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Aaron Shilo

>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.
Steve Jebson

ASKER
thanks for quick responses, looks like i'll have to try the scripts to export n import....
Steve Jebson

ASKER
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 !
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.