anyone seen this...
i cannot start the symnatec embedded database, each time i start the service it it stops i get the follwoing erros in the log..
I. 09/20 10:18:07. Starting database "sem5" (D:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db) at Tue Sep 20 2011 10:18
I. 09/20 10:18:07. Database recovery in progress
I. 09/20 10:18:07. Last checkpoint at Fri Sep 16 2011 14:57
I. 09/20 10:18:07. Checkpoint log...
I. 09/20 10:18:07. Performance warning: Database file "D:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db" consists of 13147 disk fragments
I. 09/20 10:18:18. Transaction log: sem5.log...
E. 09/20 10:18:19. *** ERROR *** Assertion failed: 100904 (9.0.2.3654)
E. 09/20 10:18:19. Failed to redo a database operation (id=1, page_no=0xd000006a, offset=0x513) - Error: Primary key for table 'SEM_CONTENT' is not unique
I. 09/20 10:18:19. *** ERROR *** Assertion failed: 100904 (9.0.2.3654)
I. 09/20 10:18:19. Failed to redo a database operation (id=1, page_no=0xd000006a, offset=0x513) - Error: Primary key for table 'SEM_CONTENT' is not unique
I. 09/20 10:18:19.
I. 09/20 10:18:19. Attempting to save dump file at 'C:\WINDOWS\TEMP\sa_dump.dmp'
I. 09/20 10:18:19. Dump file saved
E. 09/20 10:18:19. Internal database error *** ERROR *** Assertion failed: 100904 (9.0.2.3654)
E. 09/20 10:18:19. Failed to redo a database operation (id=1, page_no=0xd000006a, offset=0x513) - Error: Primary key for table 'SEM_CONTENT' is not unique -- transaction rolled back
I have tried a windows defrag... but it wont defrag the datbase file so i nsuspect i need to do something else.
has anyone got any idea before i rebuild the AV server
kev