System: Purge the CUIC Database

Revision as of 19:56, 18 December 2009 by Docwikibot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Problem Summary	How do you purge the CUIC database?
Error Message	None.
Possible Cause	Some CUIC tables grow very large. Follow this procedure to schedule a job that truncates seven tables that tend to grow. Do this to constrain the database size.
Recommended Action	Open Microsot SQL Server Management Studio. Connect to the server where the CUIC database is installed. Expand "SQL Server Agent". Right-click "Jobs"; then click "New Job". On the General tab: Name : Enter a name such as 'Purge tables from CUIC database' Category : Database Maintenance Click OK. Select Steps in the left panel Click New. Step Name : Enter a name such as 'Purge Large Tables' Type: Transact-SQL script (T-SQL) Database : Select the CUIC database Commands: Enter these commands TRUNCATE TABLE AA_DataProcessingInfo TRUNCATE TABLE AA_ErrorLog TRUNCATE TABLE AA_LoadEvents TRUNCATE TABLE AA_ProfilerData TRUNCATE TABLE AA_ReportViews TRUNCATE TABLE AA_TracingData TRUNCATE TABLE AA_UserLog Select OK. Select Schedules in the left panel. Click new. Name : Daily Schedule type : Recurring Frequency : Daily Daily Frequency : Occurs once at : 1:00 AM Select OK. Select OK.
Release	Release 7.5(2).
Associated CDETS #	None.

Rating: 0.0/5 (0 votes cast)