Friday, February 24, 2012

64 bit Edition and 32bit Participate in VIRTUALSQL Cluster

Hi All

I have a requiment to update a SQL Cluster that I have, however we only have the budget to upgrade one of the servers participating in the Cluster.

Older servers are ML370 G4 Dual 3Ghz 10GB RAM - Windows 2003 Enterprise (existing)

the server I want to upgrade to is a

DL380 G5 Quad 3Ghz (Duo) - 20GB RAM - Windows 2003 Enterprise x64 edition (new)

I would also be upgrading to SQL 2005 Enterprise in the same upgrade (x64 edition on the new server)

What I want to know is if a x64bit Edition and a standard x86 edition both participate in the same VIRTUALSQL instance in a clustered environment?

Would appreciate assistance from any Microsoft people reading this post?

No,

All instances of SQL Server participating in a Cluster must be the same -either 32 bit or 64 bit.

However, you may want to consider running 32 bit SQL Server on the 64 bit Windows Server.

Or, you may forgo the Cluster, and using the 64 bit SQL Server as primary, create a Mirror server with the 32 bit server as a fail-over partner.

|||If you've got the cash for a SQL 2005 Enterprise license and a single DL380 don't skimp. Purchase another DL380, they aren't that expensive.

No comments:

Post a Comment