All about SQL Server with 32bit to 64bit cluster migration – steps to take care | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

All about SQL Server with 32bit to 64bit cluster migration – steps to take care

Recently there has been few ‘interesting’ posts that will help most of the SQL Server users in this cyber world. Here is the basic question posted by the user:
I have been tasked with migrating our SQL Server 05 Active/Passive cluster from 32bit to 64bit with as little downtime as possible. What is the best method of this. Can I just build one node and swap it out having a 32bit node and 64bit node attached or do I have to build both nodes and just reattach/restore the databases after the cluster is built?
Pretty scary isn’t it, no much time to test the implementations without knowing the implications as there was no development environment.
Eventually the user was able to upgrade (this mammoth task) based on the references available on web – for more read on this interesting task review ThisForum post.
I’ve been Blogged!!!
I am interested in the migration from sql server 2005 32 bits to 64 bits. But, I am not sure if my SQL SERVER 2005 X64 for 1 processor will run in a dual core X64 machine!.May be some one could tell me if it run ok. Thanks in advance.
The migration or upgrade from 32bit to 64 bit is no different, as in this case you have to test your application functionality and their drivers, refer to this link for further information on FAQ upgrade.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |