Is there an easy way to purge, delete or re-initialise this database to get the size down ?
Regards
Michael
SBS
Last Comment
Michael Green
8/22/2022 - Mon
Larry Struckmeyer MVP
Hi:
In the SBS console, under Monitoring, run the setup wizard. This will clear the history so you will not have comparisons in the reports, but it will lower the space consumed.
How big is your system partion? 1.5 GB is not "huge" for this database.
Michael Green
ASKER
Where is 'Monitoring' located on the SBS2008 console ?
Larry Struckmeyer MVP
Sorry, keep getting the versions mixed....
You still are nowhere near any limits on these files. If your system partition is lacking free space, either the partition is too small or there are other things using the space.
Here are two articles that explain it. Note, Please read them both to the end.
The customer's C: drive is quite small - hence the issue.
I read all three articles - have seen this about updateSBSMonitoring.sql before.
I ran updateSBSMonitoring.sql per the procedure.
It did NOT decrease the database size - it INCREASED IT !. And the log file size TOO ! (to over a gig).
Is this the result you expected ?
Larry Struckmeyer MVP
Not what I expected and not sure what that is about, but you will be fighting this forever. Probably better to increase the size of the system partition.
Also, "run as administrator" either wirdirstat or treesizepro to see what else is consuming space on that system.
In the SBS console, under Monitoring, run the setup wizard. This will clear the history so you will not have comparisons in the reports, but it will lower the space consumed.
How big is your system partion? 1.5 GB is not "huge" for this database.