Backup/Retore from  10.50.1617 to 10.00.1600

Steve Jebson
Steve Jebson used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
You cannot restore the backup from a higher version to a lower version, either you need to upgrade the lower version, or create a script or use import/export wizard to copy the objects
Gary DewrellSenior Network Administrator

Commented:
10.00.1600 is SQL 2008 NOT R2.  You cannot restore from a higher version to a lower version.
Aaron ShiloChief Database Architect

Commented:
hi

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

worth the try.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

AneeshDatabase Consultant
Top Expert 2009

Commented:
>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.
Aaron ShiloChief Database Architect

Commented:
>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 JebsonDeveloper

Author

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

Author

Commented:
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 !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial