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

Create a technical support case if you need further support.

Reducing the database size of InterScan Messaging Security Suite (IMSS)

    • Updated:
    • 5 Mar 2014
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • InterScan Messaging Security Suite 7.5 Windows
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary
Reduce the size of the IMSS database when you encounter any of the following scenarios:
  • The disk where the IMSS database is located is almost full.
  • The IMSS database is about to reach the size limit of SQL Express servers.
Details
Public
Back up the IMSS and EUQ databases
This will allow recovery in case unexpected problems arise.
  1. Stop all IMSS services.
  2. Open a command prompt and then type "osql.exe -U sa".
  3. Type the password.
  4. Create a backup of the IMSS database.
    1. At 1>, type the following command:
       backup database imss to disk='c:\imss.bac'
    2. At 2>, type "go".
      A message that the database backup is complete will appear.
  5. Create a backup of the EUQ database.
    1. At 1>, type "backup database imsseuq to disk='c:\imsseuq.bac'".
    2. At 2>, type "go".
      A message that the database backup is complete will appear.
  6. At 1>, type "quit" to exit the OSQL command interface.
  7. Start the IMSS services.
Reduce the size of the database
  1. Open the IMSS web console.
  2. Go to Logs > Settings.
  3. Go to the Number of days to keep logs for query field and select the lowest value allowed in your company policy.
  4. Click Save.
  5. Go to Administration > User Quarantine Access.
  6. Go to the Keep quarantined spam for field and select the lowest value allowed in your company policy.
  7. Click Save.
  8. Close the IMSS console.
  9. Using an administrator account, go to the <IMSS>/bin folder and run the dblog_janitor.exe file.
    The process will finish after a few minutes.
  10. Stop all IMSS services.
  11. Run the following command:
    osql.exe -E
    use imss
    go
    dbcc shrinkdatabase(imss)
    go
Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Deploy
Solution Id:
1060060
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.