SQL Server Knowledge Sharing Network (SqlServer-qa.net)

SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];

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. 

 

Comments

 

Ziptar said:

I've been Blogged!!!

January 16, 2008 11:26 AM
 

fmunoze said:

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.

February 27, 2008 3:57 PM
 

satya said:

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 sqlserver-qa.net/.../upgrade-blurg.aspx link for further information on FAQ upgrade.

March 3, 2008 2:43 AM

About satya

SQL Server MVP. SQL Master, Speaker & SQL Server helper. 16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities : Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above. Active member of most of the SQL Server community forums.

This Blog

Syndication



© 2000 - 2007 vDerivatives Limited All Rights Reserved.