How To Upgrade From 2005 32-Bit Failover Cluster to 2008 64-Bit Failover Cluster

Question

How To Upgrade From 2005 32-Bit Failover Cluster to 2008 64-Bit Failover Cluster

madler-797963

SSC-Addicted

Points: 425
More actions
October 7, 2010 at 9:28 pm

#227522

Does anyone have a command line script that would make it easy for me to upgrade a 32 bit 2005 failover cluster to a 64 bit 2008 fail over cluster? I'm nervous in accepting the wizard options because it doesn't indicate upgrading a fail over cluster, and it wants to install in x86 etc...
Please let me know,

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

You cannot perform an in-place upgrade from 32-bit to 64-bit.

If you already have a 64-bit OS with the 32-bit SQL, then you can install 64-bit sql on the same cluster. However, if the OS is 32-bit also, then you are looking at one of two options:

1. Backup all databases. Reformat hard drives, install 64-bit OS. Establish cluster. Install 64-bit sql.

2. Get new hardware. Install 64-bit OS, establish cluster, install 64-bit sql.

You might want to review the SQL Server 2008 Upgrade Technical Reference Guide before you start upgrading.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

madler-797963 SSC-Addicted Points: 425 More actions · Answer 2

Ah, that's not a bad idea, just installing a different instance and moving the db's.....Can that be done from RDP (e.g. the SQL cluster installation part)? The windows OS is already 64-bit

WayneS SSC Guru Points: 95461 More actions · Answer 3

madler-797963 (10/7/2010)
Ah, that's not a bad idea, just installing a different instance and moving the db's.....Can that be done from RDP (e.g. the SQL cluster installation part)? The windows OS is already 64-bit

As someone that has done it way too frequently lately, yes it can be done.

You might want to google the sp_help_revlogin procedure, which will enable you to copy logins, complete with the passwords in a hashed format, and the original SID values (which prevents orphaned users on the databases).

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

madler-797963 SSC-Addicted Points: 425 More actions · Answer 4

I was going to test this today, but when I started, I got an error telling me that the cluster shared disk was not available. How can that be if I'm running the thing on a current 2005 cluster? I checked to ensure the disks had no dependencies.

Any thoughts?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

you will need new disk resources to install the SQL 2008 instance, you wont be able to share the SQL 2005 disk resources!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉