Restoration of 32-bit database into 64-bit environment
Posted on 2011-03-03
I have made a backup of a 32-bit database using Management Studio Express (ver 10.50.1600.1).
I have a new 64-bit server where SQL Express 2008 64-bit and Management Studio Express (ver 10.0.1600.22 ((SQL_PreRelease).080709-1414) is installed.
In attempting to restore the backup onto the new server. I get the following 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.
Is my issue that I am initially working with SQL Express 2008 R2 and the new installation is NOT R2???
Otherwise, what's the problem?