asked on

Restoration of 32-bit database into 64-bit environment

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?

Grant Berezan

To put it briefly, yes. :) The destination SQL version has to be equal to or higher than the source, unless you use an interim format, like CSV or previous version.

Olaf Doschke

"and the new installation is NOT R2???" Yes, you said so. 2008 R2 is not a service pack, it's a release 2, a major new version, rather SQL Server 2010. And even thought the 2008 is a full version while your R2 is an express version only, the version is newer and you can't restore an R2 backup in an SQL2008 Server.

Steps you can do:
Create a new database in the SQL 2008 R2 Express Server and in options set it's compatibility to SQL 2008, then copy the R2 database into that database and backup the database. Then restore that backup.

Bye, Olaf.

ASKER CERTIFIED SOLUTION

dwkor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial