Can a 64 bit database be attached to a 32 bit SQL Server?

We are planning to switch our Sql Server 2000 to Sql Server 2005 64 bit
edition. Once I attached the current database to the 64 bit Sql Server and
some changes are made to the database (new records in tables) is it possible
to go back to the 32 bit version of SQL Server with the changed database? I
created a test database on my 64 bit SQL Server, detached it and tried to
attach it to a 32 bit SQL Server. I am getting the following error "Error
602: Could not find row in sysindexes for database ID 10, object ID 1, index
ID 1. Run DBCC CHECKTABLE on sysindexes. Attaching database has failed."
Thank you
Simona wrote:
> We are planning to switch our Sql Server 2000 to Sql Server 2005 64 bit
> edition. Once I attached the current database to the 64 bit Sql Server and
> some changes are made to the database (new records in tables) is it possible
> to go back to the 32 bit version of SQL Server with the changed database? I
> created a test database on my 64 bit SQL Server, detached it and tried to
> attach it to a 32 bit SQL Server. I am getting the following error "Error
> 602: Could not find row in sysindexes for database ID 10, object ID 1, index
> ID 1. Run DBCC CHECKTABLE on sysindexes. Attaching database has failed."
> Thank you
>
You're not only crossing platforms, you're also crossing product
versions. Databases are transportable between platforms (i.e. 64-bit to
32-bit and vice-versa) but not between versions. You can go from SQL
2000 to SQL 2005, but not the reverse.
Tracy McKibben
MCDBA
http://www.realsqlguy.com