MSDE DB nearly full

[NickFerrar]

Hi,

I had an issue where my ePO's DB hit the 2GB limit, I've managed to clear events and run the SQLMAINT procedure to reclaim space. It dropped the DB size to about 750MB which solves my immediate issue however I still think this is way too high but can't figure out what's using the space (on another ePO system we run about twice as many computers connect and it's DB is 150MB).

I've tried the the stored procedure sp_spaceused but it doesn't really tell me much, are there any other utilities or things I should look out for to figure out why the DB is so big?

 

[AVChap]

Prune the transaction logs.

AVChap

“I have not failed 700 times. I have not failed once.
I have succeeded in proving that those 700 ways will not work.
When I have eliminated the ways that will not work,
I will find the way that will work.”
--Thomas Edison

 

[NickFerrar]

Whereabouts can I do that? I've deleted the events within the ePO reporting. If you mean the task log is there any way to do that without opening the log on the ePO server (it's a v3 ePO and the ePO console hangs when you try and open the task log).