June 29, 2011 at 3:34 am
How Can I Restore the backup file from Sql server 2008 enterprise to SQL server 2008 express edition :
In general restoration process , I got the following error:
The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169)
----
somebody suggest the good idea to do that.
June 29, 2011 at 3:38 am
you can't sorry,
one option would be use ssis to copy the data across.
June 29, 2011 at 3:42 am
Any other option .. Like, Using SSMS.. or T-Sql
June 29, 2011 at 3:46 am
well you could use SSMS to generate the T-SQL scripts from your enterprise server and run these against the express server, also in 2008 you get the option of scripting the data.
Though the point is that they are different versions of sql server and enterprise has many features not in express so this is why the restore option wont work and the scripts may or may not run depending on how many enterprise only features you are using
June 29, 2011 at 3:49 am
generated script is not executing in express edition .. also copy database not working.
June 29, 2011 at 3:51 am
did you read what i wrote about them being two different versions and that the script may or may not work depending on what features of enterprise you have used? ?
June 29, 2011 at 3:54 am
so, now I have to use SSIS package ? or you can suggest something....
June 29, 2011 at 4:01 am
It is really a two step proces,
step one would be to create the objects in the new database. I would do this by scripting out each object and check whether it is compatiable or not with express. if it is then run this script against the express database to create the object.
step two would be to copy the data across, this can be done with ssis or bcp or by scripting out the data into insert statements (there are other ways, but I would use ssis)
June 29, 2011 at 4:53 am
Thanks,,
I used SSIS ,,
It is working fine.
June 29, 2011 at 5:14 am
Restoring a database from higher version to lower version of SQL server[/url]
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 29, 2011 at 5:50 am
... or upgrade sql express to sql express R2. Restore should work assuming the total datafile(s) size is under 10 GB (doesn't matter if the space is used or not, it's the size of the data files that counts).
June 29, 2011 at 6:04 am
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2. Restore should work assuming the total datafile(s) size is under 10 GB (doesn't matter if the space is used or not, it's the size of the data files that counts).
I am not sure that will help as there will still be compatibility issues around going from enterprise to express
June 29, 2011 at 6:19 am
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.
^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now, assuming you haven't applied any CUs to the enterprise instance, I would do as Mr. Ninja suggested and just use SQL Express 2008 R2. Then regular backup/restore should suffice.
SQL Server 2008 - 10.0.1600
SQL Server 2008 R2 - 10.50.1600
June 29, 2011 at 6:25 am
calvo (6/29/2011)
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now, assuming you haven't applied any CUs to the enterprise instance, I would do as Mr. Ninja suggested and just use SQL Express 2008 R2. Then regular backup/restore should suffice.
SQL Server 2008 - 10.0.1600
SQL Server 2008 R2 - 10.50.1600
It could matter if they're using Enterprise only functionality. But assuming a vanilla database, you're correct.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 29, 2011 at 6:32 am
Grant Fritchey (6/29/2011)
calvo (6/29/2011)
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now, assuming you haven't applied any CUs to the enterprise instance, I would do as Mr. Ninja suggested and just use SQL Express 2008 R2. Then regular backup/restore should suffice.
SQL Server 2008 - 10.0.1600
SQL Server 2008 R2 - 10.50.1600
It could matter if they're using Enterprise only functionality. But assuming a vanilla database, you're correct.
Very good reminder.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply