Javascript must be enabled to download our products and perform other essential functions on the website.

ionicons-v5-m
ionicons-v5-j
Buy Now Download Free Trial
ionicons-v5-m
ionicons-v5-f

How to Shrink Database Files

PA File Sight can use MS SQL Server or an embedded SQLite database to store it's data. This can be changed in Database Settings. You can control how much data is kept by adjusting the Database Cleanup Settings in the Database Settings dialog.

If you find the embedded SQLite database is using too much space (the files are stored in C:\Program Files\PA File Sight\Databases ) you can do the following to shrink the database files:

  1. Change the Database Cleanup Settings so that data is kept for a shorter amount of time.
  2. Because the databases get cleaned up about once per day, wait a day for the databases to get cleaned up.
  3. After the database files have been cleaned up, they will not be smaller, but there will be empty space in the database files. To reclaim the empty space, stop the PA File Sight service and run:

    C:\Program Files\PA File Sight\FileSightSvc.exe /COMPRESS_DATABASES

    Extra disk space is needed for this operation as a copy of each database is made during the cleanup step. You will see the following dialog:

When the compressing step is finished, you should start the PA File Sight service.

PA File Sight

Help Map