Microsoft KB Archive/929052

= How to change the database compaction time in Antigen and in Microsoft Forefront server security products =

Article ID: 929052

Article Last Modified on 9/19/2007

-

APPLIES TO


 * Microsoft Forefront Security for Exchange Server
 * Microsoft Forefront Security for SharePoint
 * Microsoft Antigen for Exchange
 * Microsoft Antigen for SMTP Gateways
 * Sybari Antigen 8.0 for IM
 * Sybari Antigen 8.0 for Microsoft Exchange
 * Sybari Antigen 8.0 for Microsoft SharePoint Portal Server
 * Sybari Antigen 8.0 for SMTP Gateways

-



Notice
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



INTRODUCTION
This article describes how to configure database compaction time in the following programs:
 * Sybari Antigen 8.0
 * Microsoft Antigen 9.0
 * Microsoft Forefront Security for Exchange Server
 * Microsoft Forefront for SharePoint



MORE INFORMATION
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

Typically, Antigen 8.0 and later versions of Antigen run daily database management functions on the Incident.mdb database and on the Quarantine.mdb database. The CompactIncidentDB function and the CompactQuarantineDB function are run to delete stale database records and to delete stale Quarantine items.

By default, these functions are run at 02:00 local time. However, you may want to compact the databases at a different time. To run the compaction functions at a different time, you must add a registry entry. To do this, follow these steps.  Click Start, click Run, type Regedit, and then press ENTER. In the registry tree, locate and then click the following registry subkey depending on the program that you use:  On the Edit menu, point to New, and then click String Value. Type CompactDatabaseTime, and then press ENTER. Right-click CompactDatabaseTime, and then click Modify. In the Value data box, type 21:00, and then click OK

Note You must type the time value by using the 24-hour (hh:mm) format. Type the time value that is based on the local time in which you want the compaction functions to run. Exit Registry Editor.</li> Click Start, point to Settings, and then click Control Panel.</li> Double-click Administrative Tools, and then click Services.</li> Right-click AntigenService or FSCController depending on the program that you use, and then click Restart.</li> Close the Services Microsoft Management Console (MMC) snap-in.</li></ol>

Additional query words: odbc compactdatabase

Keywords: kbdatabase kbexpertiseadvanced kbhowto KB929052

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.