0

I am trying to restore a database onto a clean install of MS SQL Server 2008 R2. I am using the same installation CD as with the original computer. That PC has since died and I now need to restore the Databases onto this new computer.

When I go to restore, it says it cannot be restored because it was created by a different version of the server (10.50.1617) than this server (10.50.6000)

How can this be true if I used the same installation CD and don't remember updating anything?

Any help would be greatly appreciated.

1
  • Maybe you run some update? – peterh Jan 22 '15 at 9:15
1

Based on the build numbers you've provided, the original computer was running an updated version of SQL Server 2008 R2 RTM, while the newly installed version is SQL Server 2008 R2 Service Pack 3.

Try removing the Service Pack and doing the restore again.

2
  • is it possible to me to upgrade the newly installed version up to the original computers build number? I roll back the original machine. – KriiV Jan 27 '15 at 1:03
  • Other way around actually, you need to downgrade the newly installed version to SQL Server 2008 R2 RTM, so that they more closely match. The only problem is that RTM's build number is 10.50.1600 while yours is 10.50.1617, so it's likely that the original machine had this patch installed, as outlined in this post. – GregL Jan 27 '15 at 14:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.