Setting the recovery model and logging levels for Discover databases

To properly maintain the Discover databases, control their size, and improve performance, Discover recommends using the Simple Recovery Model for SQL Server and compressing the log files.

About this task

If you are experiencing database size and performance issues, review the following steps to set the Recovery model to the Simple setting:

Procedure

  1. For each installed Discover database:
    1. In SQL Server Management Studio, right-click each Discover database and select Properties.
    2. In the dialog, select the Options page. Review the setting in the Recovery Model drop-down. To reduce the size of the database, set this setting to Simple. Click OK at the bottom of the dialog.
    3. Repeat the above steps for the other Discover databases.
  2. Then, stop the Discover Data Collector and Discover Data Service through the Windows™ Services Control Panel.
  3. In SQL Server Management Studio, for each database:
    1. Right-click the database name. Select Tasks > Shrink > Files.
    2. In the dialog, select Log from the File Type drop-down. Click OK.
    3. Repeat the above steps for the other Discover databases.
  4. After the above was completed for each database, restart the Discover services.

Results

These steps should reduce the size of your databases and reduce the disk I/O by lowering the amount of logging that is being done.