Restoring a 64-bit database to a 32-bit SQL Server database

Question

On my client site they have - SQL Server 2008 R2 64Bit Express Edition installed on a computer running Server 2008 in my development environment I have - Installed installation of 32-bit Vista and Sql Server 2008 Express Edition

My question is how to restore a 64-bit DB backup to my 32-bit DB

What I tried 1) Back up the 64-bit database and create the database on my 32-bit machine and restore it, I get an error

Recovery error for server 'egov041 \ SQLEXPRESS2008'. (Microsoft.SqlServer.SmoExtended)

System.Data.SqlClient.SqlError: The database was copied on the server with version 10.50.1600. This version is incompatible with this server running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup compatible with this server. (Microsoft.SqlServer.Smo)

2) Copy the MDF and LDF file from the server machine and attach it on my machine

I get an error

Database connection error for server 'egov041 \ SQLEXPRESS2008'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database "PwdMhToll" cannot be opened because it has version 661. This server supports version 655 and earlier. The down path is not supported. Failed to open new database "PwdMhToll". CREATE DATABASE aborted. (Microsoft SQL Server, Error: 948)

I refer 1) http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/49f0adf1-8254-4e4a-b7ce-d9406d0ab6d6

2) http://blog.sqlauthority.com/2011/03/27/sql-server-32-bit-64-bit-html5-database-backup-restore/

3) http://blogs.msdn.com/b/cindygross/archive/2010/04/01/moving-data-between-32-bit-and-64-bit-sql-server-instances.aspx?CommentPosted= true # commentmessage

From this post, I came to the conclusion that it is possible, someone tells me what is wrong with restoring my database ... Thanks in Advance

Answer 1

The best way I found this is to create a database script and execute it on another machine, this solved my problem for complete steps, please contact http://blog.sqlauthority.com/2007/08/21/sql-server -2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects

Answer 2

Your problem is not related to 32-bit or 64-bit, but you are trying to restore / attach the database to an older version.

If you want to do this, the best way is to script to dump your database (both schema and data), and then run the script on the destination instance.

Answer 3

The database was copied on the server with version 10.50.1600. This version is incompatible with this server, which runs version 10.00.2531.

This means that the original database is 2008 R2, and your local installed version is 2008 (not R2).