Hi Pierre,
Thank you for the reply.
I researched when database clean-up happens, and I found most of the answers are like this in the snapshot:
from this link DB Housekeeping
So, according to you, I can delete all unwanted projects using SonarQube web UI, purging all that project’s data from the database tables.
We use SQL server With database version 13.00.7016 and Microsoft JDBC Driver 9.2 for SQL Server version 9.2.0.0.
The database size is approximately 870GB. And we have a lot of old projects (many years) that we don’t need, and I can say hundreds of them.
So I am planning to write a script that will use APIs to delete all projects that are not needed anymore. Is this going to reduce the database size?