Imagine the magnitude of lost revenue
if your database suddenly became unavailable or
if you lost data due to corrupt files.
The key to your success in this situation is a well-defined backup and maintenance strategy.
Check out the details below of our 17-step ACT! Database Maintenance Program. If you’re already following the steps on a regular basis, fantastic! If not, you can get your database back to mint condition by letting us check it over for only $145.
If an area of concern is discovered (and it usually is), you’ll be advised what action needs to be taken. You can correct the issue yourself or we can do it for you. Just like your mechanic, we’ll provide an estimate of our services before we begin making the adjustments.
Don’t wait! Contact me today to schedule your 17-step database maintenance and be sure your database is backed up!
Training Solutions 17-Step Database Maintenance Program:
1. Document current Act! version, Service Pack, and Hotfix. Determine if more current ones are available and if they should be installed.
2. Document active and inactive users and their security roles. Determine if there are at least two Act! Administrators in database.
3. Document database attachment folder size to verify it is not growing too large for your version of SQL.
4. Notate which database is currently being used. Unused databases attached to SQL slow down the performance of ACT!
5. Verify if database backup is being made by Act! Scheduler. Your database may not have been backed up by your server backup software!
6. Verify if database is being checked and repaired weekly by Act! Scheduler. Act! will run faster, take up less space, and errors can be corrected by running this.
7. Document path to backup zip file and size of backup to be sure it is in a location that your server backup software is finding.
8. Run manual Check, Repair and Reindex on Act! database.
9. Perform other necessary diagnostics.
10. Document number of uncleared activities, which is the number one issue that slows down Act!
11. Document number of cleared activities to determine if old data needs to be removed.
12. Document data inconsistencies in primary fields such as state and email.
13. Document empty ID/Status field and create a dynamic group of those contacts. The ID/Status is one of the most important fields in ACT! and needs to be populated for successful use of Act!
14. Document empty Email field and create group of those contacts.
15. Scan database for duplicates based on Company, Contact and Phone; and Company, Contact and Address 1 and document those duplicates. A contact should be in the database only once!
16. Document how Act! Update preference on the server is set to prevent users from accidentally updating their workstation.
17. If using remote databases, document the last time the users successfully synced.