Endpoint Protection

I recently moved the sem5.db to another drive due to the size of the file. I followed the instructions listed in http://www.symantec.com/connect/forums/move-sem5db-sep-11 

Afterwards, I am no longer able to start the embedded database service.    I have tried doing a repair.   What options do I have here?

See this KB for more info -
http://service1.symantec.com/support/ent-security.nsf/docid/2007102607432048

Thanks for the quick reply, but that doesn't address my problem at all.  I can't get the database service to start, therefore I can't back it up either. 

Do you have the backup of your database ( time stamped zip file not the sem5.db ) and server private key folder ? 
If yes then you can restore that database and follow the disaster reovery process.

If you do not have the database backup then I think you are more or less stuck.

You can also paste the errors, if any, from  \program files\symantec\symantec endpoint protection manager\db\out.log 

. 07/08 11:14:44. Copyright © 1989-2007 Sybase, Inc.
I. 07/08 11:14:44. Portions Copyright © 2002-2007, iAnywhere Solutions, Inc.
I. 07/08 11:14:44. All rights reserved. All unpublished rights reserved.
I. 07/08 11:14:44.
I. 07/08 11:14:44. This software contains confidential and trade secret information of
I. 07/08 11:14:44. iAnywhere Solutions, Inc.
I. 07/08 11:14:44. Use, duplication or disclosure of the software and documentation
I. 07/08 11:14:44. by the U.S. Government is subject to restrictions set forth in a license
I. 07/08 11:14:44. agreement between the Government and iAnywhere Solutions, Inc. or
I. 07/08 11:14:44. other written agreement specifying the Government's rights to use the
I. 07/08 11:14:44. software and any applicable FAR provisions, for example, FAR 52.227-19.
I. 07/08 11:14:44.
I. 07/08 11:14:44. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 07/08 11:14:44. Adaptive Server Anywhere Developer Edition
I. 07/08 11:14:44.
I. 07/08 11:14:44. 4 logical processor(s) on 2 physical processor(s) detected.
I. 07/08 11:14:44. Networked Seat (per-seat) model. Access to the server is limited to 3 seat(s).
I. 07/08 11:14:44. This server is licensed to:
I. 07/08 11:14:44. Developer Edition
I. 07/08 11:14:44. Restricted Use
I. 07/08 11:14:44. Running on Windows 2003 Build 3790 Service Pack 2
I. 07/08 11:14:44. 65536K of memory used for caching
I. 07/08 11:14:44. Minimum cache size: 65536K, maximum cache size: 65536K
I. 07/08 11:14:44. Using a maximum page size of 8192 bytes
I. 07/08 11:14:44. Starting database "sem5" (d:\symantec db\sem5.db) at Wed Jul 08 2009 11:14
I. 07/08 11:14:45. Transaction log: sem5.log
E. 07/08 11:14:45. Error: Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 11:14:45. Error: Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 11:14:45.
E. 07/08 11:14:45. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 11:14:45. Database server stopped at Wed Jul 08 2009 11:14
I. 07/08 13:36:38. Adaptive Server Anywhere Network Server Version 9.0.2.3654
I. 07/08 13:36:38.
I. 07/08 13:36:38. Copyright © 1989-2007 Sybase, Inc.
I. 07/08 13:36:38. Portions Copyright © 2002-2007, iAnywhere Solutions, Inc.
I. 07/08 13:36:38. All rights reserved. All unpublished rights reserved.
I. 07/08 13:36:38.
I. 07/08 13:36:38. This software contains confidential and trade secret information of
I. 07/08 13:36:38. iAnywhere Solutions, Inc.
I. 07/08 13:36:38. Use, duplication or disclosure of the software and documentation
I. 07/08 13:36:38. by the U.S. Government is subject to restrictions set forth in a license
I. 07/08 13:36:38. agreement between the Government and iAnywhere Solutions, Inc. or
I. 07/08 13:36:38. other written agreement specifying the Government's rights to use the
I. 07/08 13:36:38. software and any applicable FAR provisions, for example, FAR 52.227-19.
I. 07/08 13:36:38.
I. 07/08 13:36:38. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 07/08 13:36:38. Adaptive Server Anywhere Developer Edition
I. 07/08 13:36:38.
I. 07/08 13:36:38. 4 logical processor(s) on 2 physical processor(s) detected.
I. 07/08 13:36:38. Networked Seat (per-seat) model. Access to the server is limited to 3 seat(s).
I. 07/08 13:36:38. This server is licensed to:
I. 07/08 13:36:38. Developer Edition
I. 07/08 13:36:38. Restricted Use
I. 07/08 13:36:38. Running on Windows 2003 Build 3790 Service Pack 2
I. 07/08 13:36:38. 65536K of memory used for caching
I. 07/08 13:36:38. Minimum cache size: 65536K, maximum cache size: 65536K
I. 07/08 13:36:38. Using a maximum page size of 8192 bytes
I. 07/08 13:36:38. Starting database "sem5" (d:\symantec db\sem5.db) at Wed Jul 08 2009 13:36
I. 07/08 13:36:38. Transaction log: sem5.log
E. 07/08 13:36:38. Error: Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 13:36:38. Error: Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 13:36:38.
E. 07/08 13:36:38. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
I. 07/08 13:36:38. Database server stopped at Wed Jul 08 2009 13:36

Did you also copy all the other files from that directory as the follow up posts in that first link suggest?

the following is from the err.log

04/23 22:13:38. Fatal error: disk full C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.log
05/19 18:31:23. Fatal error: disk full C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.log
07/08 10:10:14. Share violation: another process may be using the file
07/08 10:17:38. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 10:18:01. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 10:21:05. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 10:29:08. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 10:45:14. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 11:10:53. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 11:11:35. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 11:14:45. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently
07/08 13:36:38. Cannot open transaction log file -- Can't use log file "sem5.log" since the database file has been used more recently

Try renaming sem5.log to sem5.old a new sem5.log should be created once you try to start the service.
See if this helps. 

yes, I copied all the files in that directory.

Perfect. That got the service started! Thanks.

I. 11/06 10:45:44. Finished checkpoint of "sem5" (sem5.db) at Fri Nov 06 2009 10:45
I. 11/06 10:45:44. Starting checkpoint of "sem5" (sem5.db) at Fri Nov 06 2009 10:45
I. 11/06 10:45:45. Finished checkpoint of "sem5" (sem5.db) at Fri Nov 06 2009 10:45
I. 11/06 10:44:38. Adaptive Server Anywhere Network Server Version 9.0.2.3654
I. 11/06 10:44:38.
I. 11/06 10:44:38. Copyright © 1989-2007 Sybase, Inc.
I. 11/06 10:44:38. Portions Copyright © 2002-2007, iAnywhere Solutions, Inc.
I. 11/06 10:44:38. All rights reserved. All unpublished rights reserved.
I. 11/06 10:44:38. 
I. 11/06 10:44:38. This software contains confidential and trade secret information of
I. 11/06 10:44:38. iAnywhere Solutions, Inc.
I. 11/06 10:44:38. Use, duplication or disclosure of the software and documentation
I. 11/06 10:44:38. by the U.S. Government is subject to restrictions set forth in a license
I. 11/06 10:44:38. agreement between the Government and iAnywhere Solutions, Inc. or
I. 11/06 10:44:38. other written agreement specifying the Government's rights to use the
I. 11/06 10:44:38. software and any applicable FAR provisions, for example, FAR 52.227-19.
I. 11/06 10:44:38. 
I. 11/06 10:44:38. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 11/06 10:44:38. Adaptive Server Anywhere Developer Edition
I. 11/06 10:44:38.
I. 11/06 10:44:38. 2 logical processor(s) on 1 physical processor(s) detected.
I. 11/06 10:44:38. Networked Seat (per-seat) model. Access to the server is limited to 3 seat(s).
I. 11/06 10:44:38. This server is licensed to:
I. 11/06 10:44:38.     Developer Edition
I. 11/06 10:44:38.     Restricted Use
I. 11/06 10:44:38. Running on Windows 2003 Build 3790 Service Pack 2
I. 11/06 10:44:38. 65536K of memory used for caching
I. 11/06 10:44:38. Minimum cache size: 65536K, maximum cache size: 65536K
I. 11/06 10:44:38. Using a maximum page size of 8192 bytes
I. 11/06 10:44:38. Starting database "sem5" (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Fri Nov 06 2009 10:44
I. 11/06 10:44:38. Database recovery in progress
I. 11/06 10:44:38.     Last checkpoint at Fri Nov 06 2009 10:46
I. 11/06 10:44:38.     Checkpoint log...
I. 11/06 10:44:38. Performance warning: Database file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 4477 disk fragments
E. 11/06 10:44:39. *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
E. 11/06 10:44:39. Checkpoint log: invalid bitmap page
I. 11/06 10:44:39. *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
I. 11/06 10:44:39. Checkpoint log: invalid bitmap page
I. 11/06 10:44:39.
I. 11/06 10:44:39. Attempting to save dump file at 'C:\WINDOWS\TEMP\sa_dump.dmp'
I. 11/06 10:44:39. Dump file saved
E. 11/06 10:44:39. Internal database error *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
E. 11/06 10:44:39. Checkpoint log: invalid bitmap page -- transaction rolled back
I. 11/06 15:11:34. Adaptive Server Anywhere Network Server Version 9.0.2.3654
I. 11/06 15:11:34.
I. 11/06 15:11:34. Copyright © 1989-2007 Sybase, Inc.
I. 11/06 15:11:34. Portions Copyright © 2002-2007, iAnywhere Solutions, Inc.
I. 11/06 15:11:34. All rights reserved. All unpublished rights reserved.
I. 11/06 15:11:34. 
I. 11/06 15:11:34. This software contains confidential and trade secret information of
I. 11/06 15:11:34. iAnywhere Solutions, Inc.
I. 11/06 15:11:34. Use, duplication or disclosure of the software and documentation
I. 11/06 15:11:34. by the U.S. Government is subject to restrictions set forth in a license
I. 11/06 15:11:34. agreement between the Government and iAnywhere Solutions, Inc. or
I. 11/06 15:11:34. other written agreement specifying the Government's rights to use the
I. 11/06 15:11:34. software and any applicable FAR provisions, for example, FAR 52.227-19.
I. 11/06 15:11:34. 
I. 11/06 15:11:34. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
I. 11/06 15:11:34. Adaptive Server Anywhere Developer Edition
I. 11/06 15:11:34.
I. 11/06 15:11:34. 2 logical processor(s) on 1 physical processor(s) detected.
I. 11/06 15:11:34. Networked Seat (per-seat) model. Access to the server is limited to 3 seat(s).
I. 11/06 15:11:34. This server is licensed to:
I. 11/06 15:11:34.     Developer Edition
I. 11/06 15:11:34.     Restricted Use
I. 11/06 15:11:34. Running on Windows 2003 Build 3790 Service Pack 2
I. 11/06 15:11:34. 65536K of memory used for caching
I. 11/06 15:11:34. Minimum cache size: 65536K, maximum cache size: 65536K
I. 11/06 15:11:34. Using a maximum page size of 8192 bytes
I. 11/06 15:11:34. Starting database "sem5" (C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Fri Nov 06 2009 15:11
I. 11/06 15:11:34. Database recovery in progress
I. 11/06 15:11:34.     Last checkpoint at Fri Nov 06 2009 10:46
I. 11/06 15:11:34.     Checkpoint log...
I. 11/06 15:11:34. Performance warning: Database file "C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 4477 disk fragments
E. 11/06 15:11:34. *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
E. 11/06 15:11:34. Checkpoint log: invalid bitmap page
I. 11/06 15:11:34. *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
I. 11/06 15:11:34. Checkpoint log: invalid bitmap page
I. 11/06 15:11:34.
I. 11/06 15:11:34. Attempting to save dump file at 'C:\WINDOWS\TEMP\sa_dump.dmp'
I. 11/06 15:11:35. Dump file saved
E. 11/06 15:11:35. Internal database error *** ERROR *** Assertion failed: 201819 (9.0.2.3654)
E. 11/06 15:11:35. Checkpoint log: invalid bitmap page -- transaction rolled back
I. 11/07 10:38:00. Adaptive Server Anywhere Network Server Version 9.0.2.3654

@shahid - Please open a new Discussion.