This article provides details on how to shrink the OfficeScan database and limit its transaction log to 20GB.
To limit the OfficeScan database and save space:
- On the OfficeScan server, navigate to Control Panel > Services and stop the OfficeScan Master Service.
- Go to the SQL server where the OfficeScan database resides and open SQL Management Studio.
- Log in with an account that has permission to view and configure the OfficeScan database. By default, it's hostname-OSCE.
- Expand databases on the left side and make a backup of the OfficeScan database:
- Right-click on the database.
- Choose Tasks > Back Up.
- Press Enter.
- Choose backup type "Full" and backup component "Database".
- Configure the destination.
- Click Ok.
- To shrink the OfficeScan database and save on space, right-click on hostname-OSCE > Tasks > Shrink > database.
- To limit OfficeScan's database transaction log:
- Right-click on hostname-OSCE and choose "Properties".
- Click Files.
- 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.
- 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.
- Enable autogrowth:
- Under Maximum File Size, choose "Limited to".
- Change the default (2,097,152) to "2,000".
- Click Ok.
- In the main window, click Ok.
- Go back to the OfficeScan server and restart the OfficeScan Master Service.
- Log in to the OfficeScan console and go to Logs > Log maintenance.
- Review the data and make sure that the database is maintained properly and keep only what you need.
- Scroll to the bottom and click Save.
- Configure the SQL server to have a scheduled database backup:
- 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.
- 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.