Tuesday 23 April 2013

Move the Symantec SEM5.db file to another partition

We have an SBS 2008 Standard setup that’s getting really tight on the system drive.

We’ve pretty much moved everything and anything we can off of the system partition to keep space as free as possible.

One of the last pieces to be moved is the SEM5.db file that runs around 2GB or more.

To move that file we followed these instructions:

  1. Go to services.msc
  2. Stop the Symantec Endpoint Protection Manager Service
  3. Stop the Symantec Embedded Database Service
  4. Go to \Program Files\Symantec\Symantec Endpoint Protection Manager\db and cut the sem5.db file and paste it to the new drive
  5. Click Start
  6. Click run
  7. Type regedit
  8. Go to HKey_Local_Machine\system\CurrentControlSet\Services\ASANYs\Parameters\ click on the Parameters option in the right hand side column and change the path of the sem5.db database file to the new location as New Drive:\Folder name
    • Our folder: image
  9. Restart the Symantec Embedded Database Service from services.msc
    • NOTE: We were able to log on to the SEP Management Console once we had both services started at this point.
  10. Go to Administrative Tools
  11. Click on Data Sources (ODBC)
  12. Click on System DSN tab
  13. Click on Configure button
  14. Highlight the database tab and replace the path for the sem5.db file and ensure connectivity by clicking on Test Connection
  15. Go to Management Server configuration Wizard and perform the server reconfiguration

That freed up over 2GB of storage space which at this point for this particular SBS is _a lot_ of space to be had! :)

Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book

Chef de partie in the SMBKitchen
Find out more at
www.thirdtier.net/enterprise-solutions-for-small-business/

Windows Live Writer

1 comment:

redleg said...

Thanks for that tip, just put it to good use on an old SBS2003 with SEP 12.1.

Only difference was the registry key was SQLANYs_sem5

Mike