SQL Server Pro
Connect With Us
Home > Project Plans > SQL Server 2008 > Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

Minimize downtime by taking advantage of SQL Server 2008’s failover clustering features
Dec. 8, 2009 Denny Cherry | SQL Server Pro

In my previous articles, Planning and Implementing a SQL Server Cluster and Set Up a SQL Server 2008 Cluster, I showed you how to install SQL Server 2008 and SQL Server 2005 in a cluster. In this article, I’ll combine these two installations as I show you how to upgrade an existing SQL Server 2005 cluster to a SQL Server 2008 installation. As we learned when building a SQL Server 2008 cluster in “Set Up a SQL Server 2008 Cluster,” the SQL Server installer has changed ...

Buy This Project Plan Now!

This content is part of the Migrating to SQL Server 2008 & 2008 R2 Project Plan.

Purchase this project plan to receive:

  • Step-by-step guidance for managing your project, start to finish
  • Tested advice for preparing for and completing your project
  • Insights to help you avoid common pitfalls and traps
Buy Now!

Register
Already registered? here

Discuss this Article 7

rwenger
on Nov 4, 2012
I'm confused between your article where it say planning the upgrade versus doing the upgrade. In planning the upgrade you state to start with the active node. In the Updage paragraph, you state start with th passive node. What's the difference betwen the planning upgrad and performing the upgrade? As far as a fallback plan, we can intall ss 2008 R2 on one node test on that node and then if everything works upgraded node update the active node. Thanks in advance
Fabrizio.Faleni
on Mar 23, 2010
I am planning a consolidation 2 nodes SQL Failover Cluster that will host 5 instances of SQL Server (four OLTP and one OLAP) on a Windows 2008R2 EE Cluster. Unfortunately one of the application accessing one database, will have support only if the DB engine is SQL 2005, while the four others are SQL 2008 certified. Would you create a "mixed" cluster hosting 4 instances of SQL 2008 and one instance of SQL 2005 or just install only SQL 2005 for all instances? An upgrade could be made in the future for one or all instances in both cases, right? All applications using that cluster are mission critical... Thanks for your advise.
dkalemis
on Feb 28, 2010
In the section "Planning the Cluster Upgrade", the sentence "Youll upgrade the active node first, then the passive node", should read instead: "Start by upgrading the passive node".
Gary (not verified)
on Jun 15, 2010
Fabrizio.Faleni
on Mar 23, 2010
I am planning a consolidation 2 nodes SQL Failover Cluster that will host 5 instances of SQL Server (four OLTP and one OLAP) on a Windows 2008R2 EE Cluster. Unfortunately one of the application accessing one database, will have support only if the DB engine is SQL 2005, while the four others are SQL 2008 certified. Would you create a "mixed" cluster hosting 4 instances of SQL 2008 and one instance of SQL 2005 or just install only SQL 2005 for all instances? An upgrade could be made in the future for one or all instances in both cases, right? All applications using that cluster are mission critical... Thanks for your advise.
Fabrizio.Faleni
on Mar 23, 2010
I am planning a consolidation 2 nodes SQL Failover Cluster that will host 5 instances of SQL Server (four OLTP and one OLAP) on a Windows 2008R2 EE Cluster. Unfortunately one of the application accessing one database, will have support only if the DB engine is SQL 2005, while the four others are SQL 2008 certified. Would you create a "mixed" cluster hosting 4 instances of SQL 2008 and one instance of SQL 2005 or just install only SQL 2005 for all instances? An upgrade could be made in the future for one or all instances in both cases, right? All applications using that cluster are mission critical... Thanks for your advise.
Gangadhar pisari (not verified)
on Jun 15, 2010
We have 2-node a/p cluster setup for SQL Server 2005 with SP3 and have SSIS installed only on Node1.

No SSIS installed on Node2. Now, I want to perform in-place upgrade to SQL Server 2008 and came to know that we should have same features installed on both nodes in order to perform in-place upgrade to SQL Server 2008.

Question:

Do we need to install SSIS on Node2 and perform in-place upgrade to SQL Server 2008?

Thanks

Please or Register to post comments.

Related Articles
Migrating to SQL Server 2008 & 2008 R2 Project Plan

<<< Back to the Project Plan


Planning

SQL Server 2008 R2 Requirements

SQL Server Version Build Numbers

SQL Server 2008 R2 New Features

Migrating

Upgrading to SQL Server 2008 R2

Migrating to SQL Server 2008

How to Upgrade to SQL Server 2008 from SQL Server 2000

Tools for Migrating Access to SQL Server

SQL Server 2008 - Episode 8: How Do I Upgrade

Fine Tune Your Migration

Database Administration

Top 10 SQL Server Performance Tuning Tips

Configuring SQL Server 2008’s Resource Governor

Set Up a SQL Server 2008 Cluster

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

Compression in SQL Server 2008

An Overview of SQL Server High Availability Options

3 Log Shipping Techniques

Efficient Data Management in SQL Server 2008, Part 1

Efficient Data Management in SQL Server 2008, Part 2

Build a Policy-Based Management System for SQL Server 2008

Synchronizing Disparate Data with Master Data Services

Introducing the SQL Server Utility

Tips for Using SQL Server Management Studio 2008

SQL Server 2008 - Episode 2: Under the Hood

SQL Server 2008 - Episode 5: Knowing Your Data

SQL Server 2008 - Episode 6: 64 Bit and You

SQL Server 2008 - Episode 7: Ready for your Environment

SQL Server 2008 R2: Enterprise Data Access for Mission-Critical Applications

Backup and Recovery

Database Mirroring in SQL Server 2008 R2 and SQL Server 2008

Advanced BACKUP and RESTORE Options

Step-by-Step Approach to Differential Backup and Recovery

Security and Auditing

Hardening SQL Server

SQL Server 2008 Boosts Built-in Encryption

SQL Server Ecryption

SQL Server 2008 - Episode 1: How Can I Secure Data

SQL Server 2008 - Episode 3: Protecting Your Data

Virtualization

Optimizing SQL Server Performance in a Virtual Environment

7 Best Practices for Running SQL Server on Hyper-V

T-SQL

Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used

Planning and Implementing a SQL Server Cluster

More SQL Server 2008 T-SQL Improvements

SQL Server 2008’s T-SQL Development and Debugging Features

Parallelism Enhancements in SQL Server 2008

Date and Time Support in SQL Server 2008

Using SQL Server 2008 FILESTREAM Storage

Using SQL Server 2008's FILESTREAM Data Type

Simplifying Spatial Data

SQL Server 2008 - Episode 4: What About Developers

Business Intelligence

Introducing PowerPivot for SharePoint

SQL Server 2008 Change Data Capture

SharePoint and SQL Server Integration

5 Considerations for Setting up a SQL Server 2008 Backend for SharePoint 2010

SSRS 2008 R2 and SharePoint 2010 Integration

PowerPivot and Excel

How to Create PowerPivot Applications in Excel 2010

A Walkthrough of PowerPivot for Excel 2010

A Walkthrough of PowerPivot for Excel 2010

Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth

Managed Self-Service BI

SQL Server Reporting Services

Unlock the Secrets of SQL Server 2008 Reporting Services

A Candid Look at Report Builder 3.0

SQL Server Reporting Services

Use Checkpoints to Restart Failed SSIS Packages

SSIS Novices’ Guide to Data Warehouses: Moving Data into the Data Warehouse

SQL Server Reporting Services

Backup Basics for SQL Server Analysis Services

SQLMag.com
Related Sites
Copyright © 2013 Penton Media, Inc