Microsoft KB Archive/929870

From BetaArchive Wiki

Article ID: 929870

Article Last Modified on 1/5/2007


  • Microsoft Operations Manager (MOM) 2005


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.


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.

Keywords: kbhowto kbinfo KB929870