KSC 12 Clean WSUS Table

[m.cavazzini]

My database on SQL Server Express use almost 10GB.

With a check I saw that table’s WUS are the bigger.

I disabled WSUS service in KSC but I do not know how I can do reduce size of these table.

 

Is there a procedure to do it?

 

Ty all for helping.

 

[MilanBortel]

Hi @m.cavazzini,

I think you can do it by cleaning all updates repositories:

KSC12: Clear updates repository

Let me know if it workes 😎

Cheers,
Milan

[m.cavazzini]

Ty for suggest @MilanBortel ,

 

I try to do it but database size was not decrease.

 

Now my DB (SQL Express) is 10269MB, with 65 workstations.

 

Do you have another ideas to resolve this problem?

 

Cheers, Marco

 

[Cesare]

Hi,

if you wanna temporarily fix this problem you need to open a ticket to K Corporate Support portal, describe your scenario and ask for the “reset_wus_tables” script: this will clean up your DB from MS metadata.
Cesare

[MilanBortel]

Yep, that was my next idea @Cesare - simply go straight to SQL ;)

 

Milan

[m.cavazzini]

I write to support and they send me guide and script to repair my DB.

Ty all for help and patience