How to move SCOM databases

I found a really good article that describes how to move SCOM databases, it also describes the difference between a database that has been upgraded from 2007 R2 and one that was created during the installation of SCOM 2012:
http://systemcentertipps.wordpress.com/2013/05/15/scom-2012-how-to-move-databases-specially-when-you-did-an-upgrade-from-scom-2007-r2-before/

Advertisements

Check Database Size

There is a standard SQL report that shows how much space a database is using. In SQL Server Management Studio for SQL Server 2008 R2 and newer, right-click on the database you are interested in and select Reports->Standard Reports->Disk Usage.

There is a good description of this report, including information about how to resize a Operations Manager database in the SCOMfaq.ch blog: http://blog.scomfaq.ch/2012/06/26/scom-check-size-of-databases-sql-standard-reports/

Event ID: 29106 on RMS Server after upgrade to CU5

After an upgrade of the RMS from SCOM 2007 R2 RTM to SCOM 2007 R2 CU5 EventID 29106 started to appear in the OperationsManager EventLog every 5-15 minutes. The solution was to flush the HealtService.
1. Stop the System Center Management Service.
2. Rename the folder “Health Service State” in C:Program FilesSystem Center Operations Manager 2007.
3. Start the System Center Management Service.

References: http://qa.social.technet.microsoft.com/Forums/en/operationsmanagergeneral/thread/084d2917-f5be-44d6-8286-e4fe4cc8dd7d