Solved

Running SQL 2008 and 2005 on the same 2 node cluster

Posted on 2008-09-30
1
670 Views
Last Modified: 2011-09-20
We currently have a 2 node cluster with 2 instances of SQL 2005 that normally run in an active active config. One of our developers wants to upgrade one of the instances to 2008 while the other instance will have to stay as 2005 as the application that runs is not compatible.

Is this a supported and recommended configuration?

Any thing we should do to make the upgrade process run smoothly?
0
Comment
Question by:matthewsj11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 22604433
>Is this a supported
yes

>recommended configuration?
there is nothing, apart from the normal stuff -- 2 instances on a single machine -- configuration that "changes".
the 2 sql server instances are distinct.

>Any thing we should do to make the upgrade process run smoothly?
hopefully, the developer has tested that the upgrade does not break the applications?! ...

apart from that, note all the system parameters of the instance to upgrade, to ensure they are still applied afterwards.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question