Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have the latest SQL Server 2008 R2 installed on a W2K8 server. The version number says "10.50.1600". My problem is that my backup fails to restore on the x64 machine.

I downloaded and installed the latest from Microsoft's page for a Windows 7 Ultimate 64-bit machine. The SQL Server 2008 R2 version on this one says "10.00.4000". Now I can't backup/restore databases between the machine. I get this error:

System.Data.SqlClient.SqlError: 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.4000. 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 used the latest downloads from this page for both machines but ended up with different versions #'s: http://www.microsoft.com/express/Database/ . My question is how do I update the 64-bit machine to the "10.50.1600" version number?

EDIT:

Exact version using "SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')":

W2K8 / x86 machine = 10.50.1600.1, RTM, Express Edition with Advanced Services

W7 / x64 machine = 10.0.4000.0, SP2, Express Edition (64-bit)

share|improve this question
    
Please run the following query (in both SQL installs) and update your question to detail the output: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') –  jscott Jan 18 '11 at 14:17
    
Thx... added the info above. –  TruMan1 Jan 18 '11 at 16:05

2 Answers 2

up vote 5 down vote accepted

It's my understanding that 10.00 signifies original 2008, i.e. NOT R2. You may want to double check what you've downloaded, and that you're actually connecting to the instance you are intending to. Here's a chart of version numbers you can reference:

http://www.sqlteam.com/article/sql-server-versions

share|improve this answer

Check http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx to find out what version you need, then download and patch appropriately.

The SQL Server 2008 R2 version on this one says "10.00.4000"

No, it does not. 10.00.4000 is not a 2008 R2, so it can not identify as that. This is a 2008 Sp2, that is not the same as R2.

Better go back to downloading and this time download the correct one.

10.50.1600 is 2008 R2 RTM.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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