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?
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)