How to restore SQL Server 2008 R2 backup to SQL Server 2008 I am unable to restore a backup from a 64-bit instance onto a 32-bit instance.

Source Server:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) 


Destination server:

Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (Intel X86)   


Error while restoring:


  Restore failed for Server 'servername'
  The database was backed up on a server running version 10.50.2500. That version is incompatible with this server, which is running version 10.00.4064. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Your issue isn't with the 32-bit vs. 64-bit, but it's that you are trying to restore a database on an older version.


  The database was backed up on a server running version 10.50.2600.
  That version is incompatible with this server, which is running
  version 10.00.4064.


This means that the source DB is 2008 R2, and destination DB version is 2008 (not R2).

The Best way to do this is to Generate the script of Database and execute it on other machine.

More Reading

Raj