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. 

 

Published Jan 14 2008, 10:41 PM by satya
Filed under: , , , , ,

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

Solutions Architect and Consultant for database solutions with over 18+ years of experience in Software Engineering and Database applications using industry famous technologies & software, having awarded MVP since the year 2006. Active member, Contributing Editor & Moderator for MSDN and other popular SQL Server related forums, in addition to regular participation as a Speaker & Subject-Matter-Expert in the major events such as Microsoft Tech-Ed, SQLBits, SQLPASS and other European based conferences. Founder & Writer of www.sqlserver-qa.net [knowledge sharing network] and writer for sqlblogcasts.com/blogs/ssqanet/default.aspx site

This Blog

Syndication

Tags


.© 2010 Jude O'Kelly All Rights Reserved.