Sometimes the transaction log on the Symantec Endpoint Protection Manager database gets to be huge and it does not delete the log file. Here’s how you can manually delete the file.
1. net stop semsrv
2. net stop SQLANYs_sem5
3. del “C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\db\sem5.log”
4. net start SQLANYs_sem5
5. net start semsrv