Shrinking OfficeScan database and limiting its transaction log to 20GB

To limit the OfficeScan database and save space:

1. On the OfficeScan server, navigate to Control Panel > Services and stop the OfficeScan Master Service.
2. Go to the SQL server where the OfficeScan database resides and open SQL Management Studio.
3. Log in with an account that has permission to view and configure the OfficeScan database. By default, it's hostname-OSCE.
4. Expand databases on the left side and make a backup of the OfficeScan database:
   1. Right-click on the database.
   2. Choose Tasks > Back Up.
   3. Press Enter.
   4. Choose backup type "Full" and backup component "Database".
   5. Configure the destination.
   6. Click Ok.
5. To shrink the OfficeScan database and save on space, right-click on hostname-OSCE > Tasks > Shrink > database.
6. To limit OfficeScan's database transaction log:
   1. Right-click on hostname-OSCE and choose "Properties".
   2. Click Files.
   3. On the right side, scroll to the end and look for hostname-OSCE_Primary.ldf. This is what you will limit. You will NOT limit the .mdf file since that's the OfficeScan data.
   4. Look for a column called autogrowth/Maxsize and click on the gray box with three dots for the .ldf file. A window should pop up.
   5. Enable autogrowth:
      1. Under Maximum File Size, choose "Limited to".
      2. Change the default (2,097,152) to "2,000".
      3. Click Ok.
   6. In the main window, click Ok.
7. Go back to the OfficeScan server and restart the OfficeScan Master Service.
8. Log in to the OfficeScan console and go to Logs > Log maintenance.
9. Review the data and make sure that the database is maintained properly and keep only what you need.
10. Scroll to the bottom and click Save.
11. Configure the SQL server to have a scheduled database backup:
    1. Go back to SQL Management Studio and log in with an account that can manage the OfficeScan database. You must be a member of a sysadmin role to create and manage maintenance plans.
    2. On the left side, expand Management and right-click on Maintenance Plans and choose "Maintenance Plan Wizard".

Follow the steps to make a database backup for OfficeScan regularly. If you do not make a backup, the transaction logs will grow and keep more transactions.