GFI
English Deutsch Français Italiano Espanol
Forums  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Member List  Search  FAQ  Ticket List  Log Out

 

Database size the same after archiving and deleting

  		Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Network Security] >> GFI EventsManager >> Database size the same after archiving and deleting Page: [1]
Login
Message << Older Topic   Newer Topic >>
Database size the same after archiving and deleting - 6.May2008 7:48:47 PM   
maxsegal

 

Posts: 3
Score: 0
Joined: 6.May2008
Status: offline 		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?
Post #: 1
RE: Database size the same after archiving and deleting - 7.May2008 12:31:36 AM   
vasabi

 

Posts: 7
Score: 0
Joined: 5.Mar.2008
Status: offline 		I same this problem.
Pls.

(in reply to maxsegal)
Post #: 2
RE: Database size the same after archiving and deleting - 8.May2008 2:10:32 PM   
imatone

 

Posts: 48
Score: 0
Joined: 6.Aug.2007
Status: offline 		R U2 using ESM 8.1 Build20080318?

(in reply to vasabi)
Post #: 3
RE: Database size the same after archiving and deleting - 9.May2008 11:11:46 AM   
Sven Berger

 

Posts: 183
Score: 0
Joined: 25.Feb.2008
Status: offline 		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).


_____________________________

Sven Berger
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software

(in reply to imatone)
Post #: 4
RE: Database size the same after archiving and deleting - 12.May2008 6:43:02 PM   
maxsegal

 

Posts: 3
Score: 0
Joined: 6.May2008
Status: offline 		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.

(in reply to Sven Berger)
Post #: 5
RE: Database size the same after archiving and deleting - 13.May2008 7:34:01 AM   
Sven Berger

 

Posts: 183
Score: 0
Joined: 25.Feb.2008
Status: offline 		HI max,

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

_____________________________

Sven Berger
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software

(in reply to maxsegal)
Post #: 6
RE: Database size the same after archiving and deleting - 13.May2008 5:34:37 PM   
maxsegal

 

Posts: 3
Score: 0
Joined: 6.May2008
Status: offline 		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.

(in reply to Sven Berger)
Post #: 7
Page:   [1]
All Forums >> [Network Security] >> GFI EventsManager >> Database size the same after archiving and deleting Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


   © 2008. All rights reserved. GFI Software Home Products Download Trials Support Ordering Site Map About Us Contact us
GFI solutions: anti spam - exchange anti virus - isa server - network vulnerability scanner - event log management - USB security software - exchange archiving - fax server software