Removing Old Data from Channel Database

New Boundary Support
Install/Upgrade - General Information

The information in thie article applies to Prism Suite version 6 and newer

The Article Attachments section below contains SQL scripts that can be used to remove old data from your Channel database. There are two scripts: one to purge task results that are older than one year, and one to purge admin action logs that are older than one year. After running the scripts, you can then shrink your database using information in the Word document in the Article Attachments section.

If you don't have access to SQL Enterprise Manager to perform these tasks, you will have to download and install the free utility SQL 2005 Management Studio Express. This will give you an easy-to-use interface for performating the tasks. The Related External Links section below has a link to the download for this utility.

IMPORTANT: Before running any of the scripts, be sure to make a backup of your Channel database(s) first.


Also In This Category

On a scale of 1-5, please rate the helpfulness of this article

Not Helpful
Very Helpful
Optionally provide your comments to help us improve this article...

Thank you for your feedback!

Add Your Comments
Email Address:
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
Toolbar's wrapper  
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
Verification Code:
Last Modified: 15 Years Ago
Last Modified By: New Boundary Support
Article not rated yet.
Article has been viewed 4.8K times.
Customer Support Software By InstantKB 2015-2
Execution: 0.000. 12 queries. Compression Disabled.