Restoring an 64 SQL server 2005 backup to a 32 bit installation

Question

I am under the impression that this cannot be done, but would love to know if it can. And if so, why?

Possible duplicate of [Detaching a Microsoft SQL 32bit database and attaching it to a 64bit server.](http://serverfault.com/questions/101748/detaching-a-microsoft-sql-32bit-database-and-attaching-it-to-a-64bit-server) - question is worded differently but same answers apply — Mark Henderson, Jun 24 '10 at 23:01

score 3 · Accepted Answer · answered Jun 24 '10 at 22:54

3

This is possible the backup files are the same regardless of architecture.

answered Jun 24 '10 at 22:54

Ally Reilly

1 Answers1