Views:

To reduce the disk space usage, follow the steps below:

  1. Identify the table consuming the most disk usage, generate a report based on the utilization of disk space. Do the following:
    1. Using SQL Server Management Studio (SSMS), access the Apex One database.
    2. Right-click Apex One Database > select Reports > Standard Reports, then select either of the following:
      • Disk Usage

        Top by Disk Usage

        Click the image to enlarge.

      • Top Tables

        Top usage by Table

        Click the image to enlarge.

  2. Ensure that the database recovery is already set to Simple:
    1. From the SQL Server Management Studio (SSMS), right-click the Apex One database > select Properties > Options.
    2. Set Recovery Model to Simple.
  3. Check if the disk space is consumed by ldf or mdf file:
    1. From the SQL Server Management Studio (SSMS), right-click the Apex One database > select Properties > Files.
    2. Check the Size (MB) and the File Name.
  4. Shrink the database or delete the log files:
    • If the file that consuming the disk space is a ldf file, it means only transaction logs is consuming the space. To free up the disk space, shrink the database using the SMSS.
      1. Open SQL Server Management Studio (SSMS).
      2. Right-click Apex One database > Tasks > Shrink > select Database.
    • If the file that utilizing the storage is mdf file, this means that the number of logs are huge and need to be deleted. You can delete and tune old logs:
      1. Log on to the Apex One web console.
      2. Go to Logs > Log Maintenance.
      3. Under Logs to Delete, set the number of day/s the logs will be retain.
      4. Under Log Deletion Schedule, set the Delete action frequency.

For further assistance, please contact Trend Micro Technical Support.