KSC 12 shrink database due exteeded limit of MSSQL express

[lDm82]

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

 

[alexcad]

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

[lDm82]

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

[alexcad]

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