Maintenance

1. Database Maintenance – ACT!
--Integrity Check
--Re-index

2. What’s run:
-- (Integrity Check) Physical consistency check
-- (Re-index) Defrag table index and data if needed
-- Purge orphan data (non sync-logged)
-- Purge orphan file attachments
-- Purge sync logs
-- Purge Event/Audit Logs
-- Update index statistics

3. Databases Panel - ActDiag
--Check – detects physical inconsistencies
--Repair – attempts to correct inconsistencies
--Reindex – full index rebuild of every table and index

ActDiag tasks are low-level,  comprehensive tasks for offline use!

4. Setup ACT! Scheduler tasks for routine Maintenance and Backup
5. Backup to non-local disk
6. Consider ActDiag Reindex after:
--Import
--Mass Assign/Realign
--Purge Data
--Large Edit/Swap/Copy operations

                                                ActDiag

1. Server Tasks
--Server Configuration Manager
   Manages the SQL Server connections “to” and “from”…
   .Server Protocols
   .Client Protocols

Enable everything for Client Protocols,
disable TCP/IP for Server Protocols if
no remote client connections wanted or
needed.

2. Database Tasks
-- Datastore Location
Database Fixes>Datastore Location – when
referencing the machine by IP address
instead of name.
*If you change the PAD file host,
you’ll likely need to change the
database’s Datastore reference, as well.

Act9Demo.PAD:
<ACTDatabase name="ACT9Demo" host="192.168.1.2" location="" type="SQL" />

3. Audit Logs
--A centralized log of many pre-defined, system-captured Events
--Stored in the ACT! database
--Troubleshooting, etc.
--Purges during DB Maintenance
 (45-day retention)

4. Not all Events purge…
--Database Fixes & Rebuilds
--Schema Updates, DB Name
    & Server Name changes
--Sync Enabled
--Column adds and deletes
(new for 10.0)