Steve Jebson
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
>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.
well then its back to just export import.
ASKER
thanks for quick responses, looks like i'll have to try the scripts to export n import....
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 !
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 !