title: Restore 64 Bit Database to 32 Bit Database SQL Server
body: <p>At My Customer Site they have 
  --SQL Server 2008 R2 64Bit Express Edition Installed on Server 2008 OS Machine
  at My Development environment i have
  -- 32Bit Vista Machine and Sql Server 2008 Express Edition Installed </p>
  
  <p>My Question is how can restore back up of 64bit DB to My 32 bit DB</p>
  
  <p>What i tried
  1) Create the Back up of 64 Bit DB and Create DB on my 32 Bit Machine and Restore it 
  i get an error</p>
  
  <p>Restore failed for Server 'egov041\SQLEXPRESS2008'.  (Microsoft.SqlServer.SmoExtended)</p>
  
  <p>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.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)</p>
  
  <p>2) Copy the MDF and LDF File from the Server Machine 
  and Attach it on my machine </p>
  
  <p>i get an error</p>
  
  <p>Attach database failed for Server 'egov041\SQLEXPRESS2008'.  (Microsoft.SqlServer.Smo)</p>
  
  <p>ADDITIONAL INFORMATION:</p>
  
  <p>An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)</p>
  
  <p>The database 'PwdMhToll' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
  Could not open new database 'PwdMhToll'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)</p>
  
  <p>i refer 
  1) <a href="http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/49f0adf1-8254-4e4a-b7ce-d9406d0ab6d6" rel="nofollow">http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/49f0adf1-8254-4e4a-b7ce-d9406d0ab6d6</a></p>
  
  <p>2) <a href="http://blog.sqlauthority.com/2011/03/27/sql-server-32-bit-64-bit-html5-database-backup-restore/" rel="nofollow">http://blog.sqlauthority.com/2011/03/27/sql-server-32-bit-64-bit-html5-database-backup-restore/</a></p>
  
  <p>3) <a href="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" rel="nofollow">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</a></p>
  
  <p>From these post i concluded that it is possible, 
  does anybody suggest what is wrong with my database restore...
  Thanks in Advance </p>