[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

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

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)
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
1 Solution
 
MrAliCommented:
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
http://msdn.microsoft.com/en-us/library/ms143694.aspx

Considerations:
http://msdn.microsoft.com/en-us/library/ee210714.aspx
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks man !
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now