Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Microsoft SQL transaction log has grown to an extremely large size

    • Updated:
    • 7 Oct 2015
    • Product/Version:
    • Deep Security 8.0
    • Deep Security 9.0
    • Platform:
    • Windows 2000 Professional
    • Windows 2003 Standard Server Edition
    • Windows 2008 Standard Server Edition
    • Windows Vista 32-bit
    • Windows XP Home
Summary

When a Microsoft SQL database is set to use the Full recovery model, the transaction logs will not be purged or removed until a full back up is performed.

Details
Public

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).
Premium
Internal
Rating:
Category:
Configure
Solution Id:
1054520
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.