Reduce size of Sophos SQL database

Hi Guys
Well had an old server which was running out of HDD space and only had a 14gb HDD.
Sophos LDF file was using 2.5 GB
I found an article on Sophos website on how to reduce this size.
Here are the steps

1. Install Microsoft SQL Management Studio Express
2. Open Sophos DB
3. Confirm DB that is using space.
Right Click DB go to properties, Check Size
4. Once you find the Sophos DB using disk space open its properties page.
5. Click on Options
6. Change Recover Model to Simple
7. Click Ok
8. Create Backup of DB

Leave a Reply