• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1161
  • Last Modified:

Upgrade to System Center Configuration Manager Server 2007 R3 with SP2

Is there a way to build another node and then make it the primary site server (from RTM to R3)?
Is it a wise plan?

I would like to:
Desired outcome:
One System Center Configuration Manager Server 2007 R3 with SP2 (database will need to live on our SQL cluster, HOSTNAME: SQL1)

Current Environment:
One Microsoft System Center Configuration Manager 2007
HOSTNAME: APP2 (Current Primary Site)
Current Version: SCCM 2007 RTM  (all windows patches patched)
Current SCCM Database lives on a non-clustered SQL server (Current SQL HOSTNAME: SQL4)

I would like to end up with a completely (just one server and one database)separate server and move the existing database to our SQL cluster.

Should I upgrade to R2, R3 first?
then move the database to the cluster?
build new server in parallel?

Any suggestions are greatly appreciated and thank you for your time in advance!
1 Solution
Abduljalil Abou AlzahabInfrastructure Team Leader – Professional ServicesCommented:
I think it's not required to upgrade to R2 or R3 before move database to cluster but I prefer to keep your environment up to date and upgrade your site server to SP2 and install R3.

For your reference:
SQL Server Preparation for Setup

How to Install Configuration Manager Using a Clustered SQL Server Instance

How to Move the Site Database

Note: Configuration Manager 2007 does support moving the site database from a remote SQL Server to the local site server computer if the site server computer is running a supported version of Microsoft SQL Server.  
NorthHighlandAuthor Commented:
a-Jaleel  thank you for your response!

I should have been more clear in my question.
 I am looking for the series of steps I should take to achieve my desired outcome.

I know how to move the database as I have done this once before.  I just need a strategy with specific steps on bringing another config manager server online while decommissioning another.
Are there RMS root management servers as there is in SCOM?

Thanks again!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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