Sql-server – Migrate SCOM 2007 R2 Databases to SQL 2008 R2 (change server)

migrationscomsql serversql-server-2008-r2

UPDATE
I have a SCOM 2007 R2 server that uses a sql 2005 server.

Machine 1: SCOM (SCOM 2007 R2 – W2K3)
Machine 2: SQL2005 (SQL 2005 SP2 – W2K3)
SQL Cluster: SQLCLUSTER (SQL 2008 R2 on Cluster – W2K8R2)
Reporting Services is on one of the cluster machines as it's not cluster aware.

I Currently use SQL2005 for OperationsManager, OperationsManagerDW db, and Reporting services.

I need to know how to migrate All this (Including Reporting Services) to the cluster.

Reinstalling is not an option since I don't know how to do this, and don't want to lose data.

Microsoft released the SCOM 2007 R2 CU 4 that does support Migration to SQL 2008 R2.

I Found this KB from MS that points to this KB that does suport SQL 2008 R2: and I've successfully updated SCOM 2007 R2 to CU 4.

I've found this tutorial on updating SCOM 2007 R2 to CU 4 and followed it:

This KB says:
The feature for SQL Server 2008 database update support lets you upgrade a database for SCOM 2007 R2 to SQL Server 2008 R2. The tools for this feature are in the SupportTools folder of the update package. For more information about how to upgrade a database from SCOM 2007 R2, visit the following Microsoft TechNet article:
http://technet.microsoft.com/en-us/library/dd789004.aspx

In the following upgrade scenarios, follow the steps that are described on the "How to update a database from SCOM 2007 R2" TechNet website:
SQL Reporting Services 2005 to SQL Reporting Services 2008 Service Pack 1 (SP1)
SQL Reporting Services 2008 Service Pack 1 (SP1) to SQL Reporting Services 2008 R2

So I guess I have to upgrade to SQL 2008, and then I'll be able to migrate to SQL 2008 R2, however I already have a SQL 2008 R2 Cluster and want to simply add this databases and reporting services there, if anyone have info on this I would gladly apreciate it.

Thanks

Best Answer

SCOM 2007 R2 still does not support SQL 2008 R2 for existing installations. The latest cumulative update for SCOM (CU#3) was just released November 15 and didn't include support, so you will have a while to wait for a CU to cover it. You may be able to contact Microsoft Support and see if a hotfix is available through that route instead.

Related Topic