PURGE IMAGES TOOL
The Purge Images tool is a way the SMS user can remove image files from ticket records to reduce the size of the
tables contributing to the overall size of the database in SQL. This is useful for SQL versions such as Express which have a
limited allowed database size. (Usually 10 gig). The SMS user may select a ticket range, date range to purge, or
purge all images on the stored tickets. After purging those items the utility will run an SQL database Shrink to bring the
database down to its new reduced size. Restart the SQL server service and right click on the database in Object Explorer
in SQL to see its new size properties.
Select the related ticket windows that contain the images you wish to purge on the
right side if you only want certain types of images to get purged.
Select the Purge Images! button. You will see the following:
Type YES to continue.
The purge progress indicator will display while running.
Eventually you should see the below message.
Review the size of the database per above to verify.