August 24, 2010 at 10:12 pm
Hi,
I cannot restore databases from my web server to my sql server 2008 in my computer because it says there is a compatibility problem
Web server version 10.50.1600
My version 10.00.2531
Can I just update to the 10.50.1600 version if so where do I download the update?
Or what can I do to restore the database in my system?
Thanks
August 24, 2010 at 10:45 pm
You can't restore to lower version of SQL Server but you can restore UP (i.e. restore 2000-->2005, 2005-->2008).
The problem in your case is 10.50.1600 is SQL 2008 R2 RTM and 10.0.xx is SQL 2008. You'll have to get the SQL 2008 R2 bits and do in-place upgrade of your instance.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
August 24, 2010 at 11:35 pm
Sqlchicken (8/24/2010)
The problem in your case is 10.50.1600 is SQL 2008 R2 RTM and 10.0.xx is SQL 2008. You'll have to get the SQL 2008 R2 bits and do in-place upgrade of your instance.
Just note that R2 is a new version of SQL and, unless you have software assurance, will require purchase of new licences.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2010 at 7:23 am
Ah cool you're absolutely correct, thanks for that reminder Gail!
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
August 25, 2010 at 8:07 am
Mmm.. not good not good....
Bad luck
Thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply