Endpoint Protection

 View Only
Expand all | Collapse all

Sem5.db size over 50Gb

Migration User

Migration UserApr 23, 2009 01:26 PM

  • 1.  Sem5.db size over 50Gb

    Posted Apr 01, 2009 06:12 AM
    Hi,
    I've this trouble: we've install SEP MR4 with embedded database, but the sem5.db has reached 51Gb size.
    I've about 30 client.
    Anyone have some idea about how to solve this trouble?
    TIA


  • 2.  RE: Sem5.db size over 50Gb

    Posted Apr 01, 2009 06:31 AM


  • 3.  RE: Sem5.db size over 50Gb



  • 4.  RE: Sem5.db size over 50Gb

    Posted Apr 01, 2009 06:49 AM
    Though this has been resolved with the MR2 but since Alberto is reporting it, I guess this would be the first step. The instrauctions are in the link posted above.


  • 5.  RE: Sem5.db size over 50Gb

    Posted Apr 01, 2009 07:05 AM
    I've seen how to shring the db, but i've install MR4 (not MP1) and i'm thinking that this trouble was solved with MR2...
    Furthermore, the shrink of the db requires at least as much space as is the db and the risk that is currently running to fill the disk of the server.
    This would prevent me to carry out this operation successfully.
    No other idea?



  • 6.  RE: Sem5.db size over 50Gb

    Posted Apr 02, 2009 05:19 AM
    simeplet and quickest thing would be to export policies, blow away your SEPM and install new one (mr4mp1a) import policies and relink the clients (only 30) then i would monitor what's going on with the DB.


  • 7.  RE: Sem5.db size over 50Gb

    Posted Apr 17, 2009 03:03 PM
     MR4 mp1a seems to have solved large number of issues. I heard MP 2 is coming out early May


  • 8.  RE: Sem5.db size over 50Gb

    Posted Apr 18, 2009 09:59 AM
    I agree with pbogu. If you cant free the space to perform the activity then better export the policies, uninstall the SEPM and install it again. Get the existing clients back with SylinkReplacer. You can get that from the tech support.


  • 9.  RE: Sem5.db size over 50Gb

    Posted Apr 18, 2009 11:53 AM

    What are your settings for things like log retention and content history?



  • 10.  RE: Sem5.db size over 50Gb

    Posted Apr 18, 2009 12:06 PM
    Hi Alberto
                     Change your SEPM to retain logs for only 30 days which is quite enough i think and what is the number of clients you use?


  • 11.  RE: Sem5.db size over 50Gb

    Posted Apr 21, 2009 11:14 AM
    Use the Dbunload.exe tool to shrink it.n go through the link


    http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2008022616103648


  • 12.  RE: Sem5.db size over 50Gb

    Posted Apr 23, 2009 01:26 PM
    try to upgrade to MR4 MP1A.


  • 13.  RE: Sem5.db size over 50Gb

    Posted May 18, 2009 09:56 AM
    Dbunload works fine, but only if you free space in database. In order to make this, you need to delete rows in BINARY_FILE and ALERTS tables.

    You can mount the sem5 database using DBSERV9.EXE located in \ASA\WIN32 directory. At the same time,  create a System DSN odbc  using the Adaptive Server Anywhere Drivers. Only supply dba user credentials and ip address.
     
    Then using DBISQLC.EXE util, you can delete them.

    Execute querys:

                           delete from BINARY_FILE

    AND

                            delete from ALERTS

    it tooks over 3 hours, so be patient.

    After running dbunload.exe you can reduce database size minor to 1 GB.
         
    In my case, it  reduced 35 GB to 700 MB database size. Then, the small database was migrated to SQL Express 2008.



  • 14.  RE: Sem5.db size over 50Gb

    Posted Mar 03, 2010 02:22 AM
     may i know what are store in BINARY_FILE table ?

    I've move my current database file to a different hard drive as its' too large to perform dbunload.

    after i have run the dbunload the file size still the same at 55gb.

    I've notice that when unloading the binary_file .. it's actually taken up the most space around 30gb 



  • 15.  RE: Sem5.db size over 50Gb

    Posted Mar 03, 2010 02:25 AM
     https://www-secure.symantec.com/connect/sites/default/files/DB_Schema_Ref_Guide.pdf