90 pts.
 Upgrade SQL 2005 Cluster to SQL 2008
We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008 cluster without rebuilding the Win2008 OS

Software/Hardware used:
win 2008
ASKED: August 5, 2010  5:48 PM
UPDATED: August 9, 2010  1:51 PM

Answer Wiki:
Yes you can do an in place upgrade of the SQL Server on the cluster. Take a look at the February 2010 issue of <a href="http://www.sqlmag.com/article/clustering/upgrading-a-sql-server-2005-cluster-to-a-sql-server-2008.aspx">SQL Server magazine</a>, in it I've got an article which covers how to go the upgrade step by step.
Last Wiki Answer Submitted:  August 9, 2010  1:51 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _