Return to Question

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][1] from MS that points to [this KB][2] that does suport SQL 2008 R2: and I've successfully updated SCOM 2007 R2 to CU 4.

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

[This KB][4] 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 [1]: http://support.microsoft.com/kb/2425714 [2]: http://support.microsoft.com/kb/2449679 [3]: http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx [4]: http://support.microsoft.com/kb/2449679

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

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][1] from MS that points to [this KB][2] that does suport SQL 2008 R2: and I've successfully updated SCOM 2007 R2 to CU 4.

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

[This KB][4] 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 [1]: http://support.microsoft.com/kb/2425714 [2]: http://support.microsoft.com/kb/2449679 [3]: http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx [4]: http://support.microsoft.com/kb/2449679

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][1] from MS that points to [this KB][2] that does suport SQL 2008 R2: and I've successfully updated SCOM 2007 R2 to CU 4.

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

[This KB][4] 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 [1]: http://support.microsoft.com/kb/2425714 [2]: http://support.microsoft.com/kb/2449679 [3]: http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx [4]: http://support.microsoft.com/kb/2449679

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

SQL_4 for OperationsManager db. SQL_8 for OPERATIONSMANAGERDW db, and Reporting services.

both are SQL 2005.

I'm intending to move all these databases to a new server. Lets say SQL_10 Already provisioned with SQL 2008 R2 on Windows 2008 R2.

I need to know if there is any Blocker for this migration, and if theres a way to workaround this.

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

Reinstalling is not an option since I don't know how to do this.

I Found this KB from MS: http://support.microsoft.com/kb/2425714

And it states that SQL 2008 R2 is supported for new installations, and that the support for the migration to a sql 2008 R2 will be supported through a HotFix. I need to know if this hotfix is already in place.

UPDATE: Microsoft released the SCOM 2007 R2 CU 4 that does support Migration to SQL 2008 R2. I Just don't know how to upgrade it. Would love some help.

I've found this tutorial: http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx

This KB Article: http://support.microsoft.com/kb/2449679/en-us

That 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

So I guess I have to upgrade to SQL 2008, and then I'll be able to migrate, 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.

PS: I've already aplied the CU 4.

Thanks

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][1] from MS that points to [this KB][2] that does suport SQL 2008 R2: and I've successfully updated SCOM 2007 R2 to CU 4.

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

[This KB][4] 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

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 [1]: http://support.microsoft.com/kb/2425714 [2]: http://support.microsoft.com/kb/2449679 [3]: http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx [4]: http://support.microsoft.com/kb/2449679