04-25-2011 10:23 AM
My database reached 4.2 gigabytes this weekend, a new high for us. We have over 20,000 records and lots of attachments. All client emails and their applications get attached to the database to provide a one-stop shop of client info.
Last year, I pruned some old Opportunities out of the database but I was wondering what others did as sort of "maintenance" on their databases? Anything?
My users are a bit nervous about losing information so I'll have a fight on my hands about removing too much.
04-25-2011 12:09 PM
Is 4.2gb the size of the ADF file, or does that number also include the attachments folder? For SQL limits, the ADF file is the main for concern.
What version of SQL do you have installed (different size limits for different versions)?
What version of ACT! are they running?
04-25-2011 12:40 PM
04-25-2011 12:42 PM
Thanks for your feedback. That number does include the attachments folder. The ADF file is 43 megabytes - is that normal?
Microsoft SQL Server 2008 - Express Edition. ACT Premium 2011 version 13.0.401.0, Hot Fix 2. Sorry, I should have included that.
I went through the attachment folder and removed some erroneous files but it didn't make a significant difference. That folder alone is 4.86 gigabytes and 16,244 files.
04-25-2011 02:28 PM