NOTE: If you are running TIBCO Scribe® Insight Version 7.7 or higher, the Admin Server handles database cleanup automatically. You do not need to run the ScribeMaintenance.sql script.

TIBCO Scribe® provides the ScribeMaintenance.sql script, used to perform regular maintenance on the SCRIBEINTERNAL Database in SQL. The script is placed in the Scribe program folder during the application installation process.

The Scribe folder location can vary, but it is usually located in: C:\Program Files (x86)\Scribe
  Using the TIBCO Scribe® Insight maintenance script is a good way to keep your SCRIBEINTERNAL database clean.  As time passes and the more Scribe is used, the SCRIBEINTERNAL database starts to grow, using more resources.  A best practice to help increase performance and stabilization, is to use the TIBCO Scribe® Insight maintenance script to reduce the size of Log tables making them more relevant.
 
When you open the script in SQL Server, look for the following lines:  
 
-- EDIT THIS VARIABLE TO CHANGE THE NUMBER OF DAYS HISTORY
-- TO KEEP IN THE LOGS
SET @Days_History_To_Keep = 90
 
By default TIBCO Scribe® Insight sets the days of history to keep to 90 days. Edit the number of days to best support your business, then run the script against the SCRIBEINTERNAL database.
 
This script can be scheduled to run on a regular basis. Best practice is to have your DBA schedule this job along with other maintenance jobs.
 
If you experience any difficulties, have further questions, or cannot find the Script, contact Support using the Cases link at the top of the page.

For additional information, see the following in the TIBCO Scribe® Insight Help: ScribeMaintenance.sql, Initial Configuration Of The Insight Server, Managing Execution Log File Sizes
 

TIBCO Scribe® provides the ScribeMaintenance.sql script, used to perform regular maintenance on the SCRIBEINTERNAL Database in SQL.