Views:

If a full back up of all the transactions is required, a full back up of the Deep Security Manager database and a shrink of the transaction logs should be done on a regular basis.

Meanwhile, if a back up of all the transactions is not required, then it is recommended that the back up method be switched from Full to Simple.

Do the following:

  1. Create a full backup.
    1. From the SQL server, find the DSM database. Right-click the database, go to Properties > Options.
    2. Under Recovery model, select Simple.
    3. Right-click the DSM database.
    4. Click Tasks > Backup. Select a destination to save the backup.
    5. Verify the following should be set:
      • Database: DSM database
      • Recovery model: Simple
      • Backup Type: Full
  2. Right-click the DSM database again. Click Properties > Options. Under Recovery model, select Full.
  3. Shrink the transaction log. This task could take a long time. Do this during off-peak hours.
    1. Right-click the DSM database. Click Tasks > Shrink > Files.
    2. Under Database Files and File groups section, select Log for the File Type.
    3. Under Shrink action, select Reorganize pages before releasing unused space. Indicate a file size (Example: 10 MB).
  4. Restrict the database growth.
    1. Right-click the DSM database. Click Properties > Files.
    2. Select the DSM under Log Type File.
    3. Edit the Autogrowth value by clicking the button.
    4. Edit the value of the Maximum File Size (e.g. 20 GB).