Knowledge Base

SpaceObServer



Question / Problem

Our SQL 2005 express database has reached its maximum limit. I urgently need to purge data older than 30 days. Please provide me a sample SQL statement to purge data older than 30 days.

Answer / Solution

You canpurge data older than X days within the Configure Scans dialog (Scan >Configure Scans > Scan Options > Archive Size data for X days). You haveto run an update scan after changing this option, or run "SynchronizeDatabase Values" from within the lists context menu (context menu >Expert Settings > Synchronize Database Values).