PDF History Table Maintenance

Unlike PDF attachments, PDF History is stored in SQL table, which increases overall database size. If documents are saved to PDF History on regular basis, then the table size should be checked periodically to ensure it hasn’t grown too big.

How to check PDF History table size:

• Open SQL Management Studio and run the following query on the RFMS database:
  • sp_spaceused pdfhistory

How to check database size:

• Login to the server through SQL Management Studio.
• Expand Databases (upper left)
• Right click on RFMS database 
• Select Properties.
  • Click Files (upper left)
  • .

How to purge PDF History:

RFMS does not recommend purging data. However, PDF History is an exception.

Click on link below for instruction: 

• How to: Purge PDF History

How to prevent PDF History table size from growing too quick:

• The best way to prevent this issue is to shrink the logo used on documents.
• If needed, a simple internet search for "how to resize a logo without losing quality" will bring up various sites you can use to resize your logo.
• For best results and minimum file size, save resized logo as a new JPG file. (Don’t save over the old high quality logo in case you need it in the future.)
• In most cases, an image that is 150 pixels wide (or less) or 35 kbs should be sufficient
• To further decrease the size of the image, change its color mode to grayscale – most businesses do not print in color, so this should be acceptable.