Cleaning up GFI databases
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
Cleaning up GFI databases - 7.Aug.2008 4:05:24 PM
|
|
|
Ytsejamer1
Posts: 69
Joined: 7.Mar.2006
Status: offline
|
Hey everyone,
Another GFI question here... our databases have grown to about 12gb in size for GFI ME and MS. There's no db grooming job that was written into GFI to get rid of old items kept in the database. Is there any recommendation for limiting or cleaning up a GFI database?
Thanks!
|
|
|
|
RE: Cleaning up GFI databases - 7.Aug.2008 4:52:39 PM
|
|
|
joestern
Posts: 238
Joined: 18.Sep.2003
From: Philadelphia, PA
Status: offline
|
I think you'll find that if you compress those MDB files, they will shrink dramatically.
|
|
|
|
|
RE: Cleaning up GFI databases - 7.Aug.2008 5:00:15 PM
|
|
|
Ytsejamer1
Posts: 69
Joined: 7.Mar.2006
Status: offline
|
Sorry, i should have been more clear...i have them one one of our SQL servers...not using local access mdb files.
|
|
|
|
|
RE: Cleaning up GFI databases - 11.Aug.2008 9:18:52 AM
|
|
|
goodwillchatt
Posts: 4
Joined: 25.Jul.2007
Status: offline
|
I got the same problem ours is up to 8 gb I need a way to reduce there size any help.
|
|
|
|
|
RE: Cleaning up GFI databases - 9.Sep.2008 3:25:30 AM
|
|
|
Sql_Gull
Posts: 7
Joined: 8.Sep.2008
Status: offline
|
The post above refers to the reporter database of ME. To clean the Archive database check the following post:
http://forums.gfi.com/m_900734157/mpage_1/key_/tm.htm
_____________________________
Sql_Gull
|
|
|
|
|
RE: Cleaning up GFI databases - 9.Sep.2008 2:50:19 PM
|
|
|
Ytsejamer1
Posts: 69
Joined: 7.Mar.2006
Status: offline
|
Very good link SQL_Gull...thanks!!! i think that's going to help us. I'm going to work on putting it to use...but this should do what we need. The log_as and log_as_neutral tables are just freakin' huge (28 / 8 million respectively!!!)
|
|
|
|
 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 |
|
|
Printable Version
