KB929870 - Reasons why you should use the Simple recovery model for the MOM 2005 OnePoint and SystemCenterReporting databases

  • Article

KB is now available via https://support.microsoft.com/kb/929870

 

When the MOM 2005 Setup program creates the OnePoint database and the SystemCenterReporting database, the Setup program configures Microsoft SQL Server to use the Simple recovery model for these databases. We recommend that you do not change the recovery model for the OnePoint and SystemCenterReporting databases from the default recovery model of Simple. This article discusses the reasons why you should use the Simple recovery model.

MoreInformation Section

The OnePoint database

To provide optimal performance, we recommend that you use the Simple recovery model for the OnePoint database. The Simple recovery model lets you restore the database to the point from which it was last backed up. However, this recovery model does not enable you to restore the database to the point of failure or to a particular time.

The Simple recovery model requires a full backup of the database and of the transaction log. If you change the recovery model to Bulk-logged or to Full, you may experience performance-related problems with the OnePoint database. Additionally, you may experience increased alert latency times.

If a high level of database activity occurs because of incoming alert information, event information, performance information, or discovery data, the logged transactions may greatly increase in the OnePoint database transaction log.

The SystemCenterReporting database

We also recommend that you use the Simple recovery model for the SystemCenterReporting database. This is because the SystemCenterDTSPackageTask scheduled task transfers large amounts of data. This scheduled task transfers data from the OnePoint database to the SystemCenterReporting database. If you use a recovery model other than the Simple recovery model, you may experience excessive growth in the transaction log file.