Database size the same after archiving and deleting (Full Version)

All Forums >> [Network Security] >> GFI EventsManager



Message

maxsegal -> Database size the same after archiving and deleting (6.May2008 7:48:47 PM)

After running maintainance jobs to archive and deleting old events from the ESM database, the database is still the same size. Shouldnt the database shrink? [&:]



vasabi -> RE: Database size the same after archiving and deleting (7.May2008 12:31:36 AM)

I same this problem.
Pls.



imatone -> RE: Database size the same after archiving and deleting (8.May2008 2:10:32 PM)

R U2 using ESM 8.1 Build20080318?



Sven Berger -> RE: Database size the same after archiving and deleting (9.May2008 11:11:46 AM)

Hi maxsegal,

I think that the database size is still the same, however the free space in your database has increased. depending on your SQL Settings, the database will only increase free space, but not actually return that fre space to your harddrive. You should be able to see that in the database properties (i.e. you would need a before-and-after comparison).



maxsegal -> RE: Database size the same after archiving and deleting (12.May2008 6:43:02 PM)

Sven, thanks...hadnt seen your reply until now...that sounds right...I just need to get SQL to release the empty space...been trying several times with no luck.



Sven Berger -> RE: Database size the same after archiving and deleting (13.May2008 7:34:01 AM)

HI max,

I think this is the info you require: http://msdn.microsoft.com/en-us/library/ms190488.aspx



maxsegal -> RE: Database size the same after archiving and deleting (13.May2008 5:34:37 PM)

Yes, thats what I was doing...but for some reason it took a looooong time to actually free up the space...maybe because there was so much of it to free up...but its good now...guess I just have to be more patient.



Page: [1]