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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Gary Dewrell
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 !
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
