restore a sql server 2005 x64 db backup to sql server 2000 32-bit

When I attempt to restore a db backup from sql server 2005 x64 on my production server to a laptop that has sql server 2000 32-bit, I get a message like "Too many files". And when I go to the tab that let's you change the paths to the db files, the two path fields are blank, when normally they would show some paths.

Is this not possible to do?You cannot take a backup on sql2k5 and restore it to sql2k instance. The metadata has changed significantly in sql2k5 for sql2k to understand.

restore 64 to 32 bit

Hi

We have a running SQL server 2005 (x64) and I want to do a restretest, but I do not have a 64 server.

Is it possible to do a restore to a 32 Bit server?

Regards

Kim

It isn′t possible because the binary files of 64 BIT is different of 32 BIT. I had a bad experience with this.|||

I do not agree with the previous post I'm afraid.

The file structure of the database is EXACTLY the same for 32-bit and 64-bit. This means you can use the file on either version of SQL Server 2005.

We have a daily backup from a SQL Server 2005 x64 database that gets distributed to several x64 and x86 servers.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

Yes it's possible. I've done it quite a few times without any problems. The backups, data and log files are not 64 bit. They are just SQL Server files.

-Sue