Jump to content
oliversl

Solving the 10GB limit reached with MSSQL in KSC

Recommended Posts

Hi,
I have a KSC with MSSQL as DB backend and it just reached the 10GB free limit. What are my options in order to free space?

The issue is with the Windows Update downloads. I tried deleting them but  the task never finish, already waited 24hours. Maybe it
can not delete because of those 10GB limit.

Should I connect to the BD and manually delete some rows?

What are my options?

Many thanks
Oliver

Share this post


Link to post

I just wanted to reduce the size of the MS SQL 2012 R2 Express database. It reached 10GB and maybe deleting some windows updates will do it.

But it seems there is no way to reduce the database size in KSC by deleting stuff (logs, windows updates files, quarantine).

Its KSC 10 latest version.

Share this post


Link to post
20 minutes ago, oliversl said:

I just wanted to reduce the size of the MS SQL 2012 R2 Express database. It reached 10GB and maybe deleting some windows updates will do it.

But it seems there is no way to reduce the database size in KSC by deleting stuff (logs, windows updates files, quarantine).

Its KSC 10 latest version.

Hello.

You should not alter the KSC database manually, but once you disabled the Patch Management functionality, it should be possible to run a designated script that resets corresponding tables, and reduzes DB size.

To obtain the script, please create an incident in CompanyAccount.

Thank you.

Share this post


Link to post
hace 1 hora, Kirill Tsapovsky dijo:

Hello.

You should not alter the KSC database manually, but once you disabled the Patch Management functionality, it should be possible to run a designated script that resets corresponding tables, and reduzes DB size.

To obtain the script, please create an incident in CompanyAccount.

Thank you.

Thanks Kirill, 

Its nice to know there is a solution to delete data in an official and supported way. I want to delete all updates and all logs in order to free space in the data base file.

Will contact Kaspersky in order to obtain that script.

Regards,

Oliver

hace 1 hora, Kirill Tsapovsky dijo:

Hello.

You should not alter the KSC database manually, but once you disabled the Patch Management functionality, it should be possible to run a designated script that resets corresponding tables, and reduzes DB size.

To obtain the script, please create an incident in CompanyAccount.

Thank you.

This issue is solved, how do I mark this question as resolved?

Share this post


Link to post

×
×
  • Create New...

Important Information

We use cookies to make your experience of our websites better. By using and further navigating this website you accept this. Detailed information about the use of cookies on this website is available by clicking on more information.