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