June 29, 2012 at 1:26 am
Hi,
I recently tried to restore a backup of sql DB to my local machine from a remote machine. When i was in the mid of restoring got the below error
System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1617. 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. (Microsoft.SqlServer.Smo)
I'm running windows XP sp3
Is it possible for me to upgrade my local machine from 10.00.1600 to 10.50.1617
i got the below information as a result of select @@version
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Express Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
Please advise.
Thanks,
Sreenivasan
June 29, 2012 at 1:31 am
Yes.
look at the product version numbers to verify your current install and what to upgrade/deploy to get to the desired version.
http://sqlserverbuilds.blogspot.com/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 29, 2012 at 2:10 am
10.00 is SQL Server 2008. 10.50 is SQL Server 2008 R2. It's a different version of SQL (like 2005/2008), not a matter of patches.
If you're using SQL Express, you need to download the SQL 2008 R2 express version. If you're using any other edition, you'll need to buy the licences for SQL Server 2008 R2.
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply