Saturday, February 25, 2012

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

No comments:

Post a Comment