Menu

Search



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.


Attachments


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
Name:
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:
Details
Last Modified: 10 Years Ago
Last Modified By: New Boundary Support
Type: HOWTO
Article not rated yet.
Article has been viewed 2.9K times.
Options
Customer Support Software By InstantKB 2015-2
Execution: 0.000. 9 queries. Compression Disabled.