One Clustered SQL 2008 instance with multiple DB instances running with difference service pack ?

Posted on 2011-10-30
Last Modified: 2012-05-12
Hi All,

I'm wondering if this is possible ?

I have Clustered SQL Server 2008 Enterprise instance (plain install no SP or patch due to the SAP software not supporting it yet).

with the name PROD-SAP1 (default install no SP at all)

What I'd like to do is to create another separate DB instance with different IP address but patch it to SP3, does this can affect the other DB instance ?

With the name PROD-WebApp1 (fully patch to SP3)
    LVL 7

    Accepted Solution

    If you haven't personally seen it done, push to have it done on a VM or test environment first.  According to MS, though, there's caveats to be wary of:

    Working with Multiple Versions and Instances of SQL Server

    LVL 6

    Author Closing Comment

    by:Senior IT System Engineer
    Thanks man !

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now