Please note that this utility does not work with Symantec Endpoint Protection (SEP) 12.1 and above. Please see TECH185177 for more information on the utility that is appropriate for that version of SEP.

The Dbunload tool is provided with Symantec Endpoint Protection 11.0.2 (Maintenance Release 2). To obtain Maintenance Release 2, read the document Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.

Note: The problem that causes the embedded database to grow overly large is solved in Maintenance Release 2, but migrating to Maintenance Release 2 does not shrink the database automatically. To shrink the database, use the Dbunload tool.

To use the Dbunload tool on 32-bit Operating Systems

1. Ensure that you have available free drive space equal to 1.5 to two times the size of the database.
2. Using the Database Back Up and Restore wizard, make a backup copy of the following file:
   
   \Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
3. Stop the following services:
   • Symantec Endpoint Protection Manager
   • Symantec Embedded Database
4. Start the service Symantec Embedded Database.
5. Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:
   
   cd \Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32
   dbunload -c "uid=dba;pwd=password_set_during_install" -ar
   

Note:
If the following results are seen:

 ***** SQL error: Specified database file already in use

Stop the Symantec Embedded Database Service and run the command again.

Note:
If the following results are seen:

***** SQL error: Database server not found

Run the following command :

dbunload -c "dbf=C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db;start=dbsrv9;uid=dba;pwd=password_set_during_install" -ar

To use the Dbunload tool on 64-bit Operating Systems

On 64-bit Operating systems, the path should be changed accordingly, and only the dbunload command that specifies the full path to the sem5.db database will work. The procedure and commands will like this:

1 Stop the following services:

Symantec Endpoint Protection Manager
Symantec Embedded Database

2. Click Start > Run, type CMD, click OK, and then type the following two lines at the prompt:
cd \Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\ASA\win32
dbunload -c "dbf=C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\db\sem5.db;start=dbsrv9;uid=dba;pwd=password_set_during_install" -ar

Note:
If the following results are seen:

***** SQL error: Specified database file already in use or
 

***** Too many connections to database being replaced
Stop the Symantec Embedded Database Service and run the command again


The time to reduce the size of the database will depend on several factors, including, but not limited to: available drive space, amount of memory, speed of the processor, size of the database, and other server and background functions running on the target system at the time of dbunload being used.

Note:
"password_set_during_install" is the password supplied while installing Symantec Endpoint Protection Manager initially.

Once the dbunload process has finished, you can:

1. Restart the service Symantec Embedded Database.
2. Start the service Symantec Endpoint Protection Manager.

References
"Accessing Maintenance Release 2 for Symantec Endpoint Protection 11.0" at:

http://www.symantec.com/docs/TECH104585