Kaspersky
Question

KSC 12 shrink database due exteeded limit of MSSQL express


hello,

I’m using KSC v. 12.0.0.7734 on machine with MS SQL server 2014 express edition, so I’m limited with size of database to 10GB and I have a problem, that I can’t shrink database anymore (when I use shrink function on SQL server, I get only few megabytes free space), so I was forced several times to load older (smaller) backup to run administration service, because when I achieve that limit, I’m without control.

 

So I would like to ask you, how can I make database smaller, or what makes that 10 GB (I have network of circa 180 machines, mostly Win 10 and few Win 7), I suppose, that there will be few GB of data, that I don’t need.

 

Thank you

 


3 replies

Userlevel 6
Badge +4

you should first delete old events from the logs. (KSC-Dashboard - Events). especially the messages "ksn not reachable" often put a strain on the database.

secondly, you can reduce the retention time for the events in the policies in order to keep the database smaller in the future. 

regards
alex

I deleted logs as you sugested, it helped me with DB KAV_log, but size of main DB KAV is still 10GB.

Userlevel 6
Badge +4

check the DB-size in the admin-server-properties, please.
 


deleting the events should have reduced the size of data in the db. now you can shrink the db.
I recommend using the "administration server maintenance" task. 
 


regards
alex

Reply / Ответить