http://docwiki.cisco.com/w/index.php?title=System:_Purge_the_CUIC_Database&feed=atom&action=history 2013-05-21T07:48:01Z Revision history for this page on the wiki MediaWiki 1.16.0 http://docwiki.cisco.com/w/index.php?title=System:_Purge_the_CUIC_Database&diff=25287&oldid=prev 2009-12-18T19:56:50Z

<p>Bot: Adding {{Template:Required Metadata}}</p> <table style="background-color: white; color:black;"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr valign='top'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 19:56, 18 December 2009</td> </tr><tr><td colspan="2" class="diff-lineno">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td colspan="2">&nbsp;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Template:Required Metadata}}</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== System: Purge the CUIC Database ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== System: Purge the CUIC Database ==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> </table>

Docwikibot http://docwiki.cisco.com/w/index.php?title=System:_Purge_the_CUIC_Database&diff=20396&oldid=prev 2009-09-04T15:52:28Z

<p>1 revision</p> <table style="background-color: white; color:black;"> <tr valign='top'> <td colspan='1' style="background-color: white; color:black;">← Older revision</td> <td colspan='1' style="background-color: white; color:black;">Revision as of 15:52, 4 September 2009</td> </tr></table>

Cchetty http://docwiki.cisco.com/w/index.php?title=System:_Purge_the_CUIC_Database&diff=20395&oldid=prev 2009-09-03T21:20:03Z

<p></p> <p><b>New page</b></p><div>== System: Purge the CUIC Database ==<br /> <br /> {| border=&quot;1&quot;<br /> |-<br /> ! '''Problem Summary'''<br /> | How do you purge the CUIC database?<br /> |-<br /> ! '''Error Message'''<br /> | None.<br /> |-<br /> ! '''Possible Cause'''<br /> | 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.<br /> |-<br /> ! '''Recommended Action'''<br /> |<br /> # Open Microsot SQL Server Management Studio.<br /> # Connect to the server where the CUIC database is installed.<br /> # Expand &quot;SQL Server Agent&quot;.<br /> # Right-click &quot;Jobs&quot;; then click &quot;New Job&quot;.<br /> # On the General tab:<br /> #* Name : Enter a name such as 'Purge tables from CUIC database'<br /> #* Category : Database Maintenance<br /> # Click OK.<br /> #Select Steps in the left panel<br /> #Click New.<br /> #* Step Name : Enter a name such as 'Purge Large Tables'<br /> #* Type: Transact-SQL script (T-SQL)<br /> #* Database : Select the CUIC database<br /> #* Commands: Enter these commands<br /> #**TRUNCATE TABLE AA_DataProcessingInfo<br /> #**TRUNCATE TABLE AA_ErrorLog<br /> #**TRUNCATE TABLE AA_LoadEvents<br /> #**TRUNCATE TABLE AA_ProfilerData<br /> #**TRUNCATE TABLE AA_ReportViews<br /> #**TRUNCATE TABLE AA_TracingData<br /> #**TRUNCATE TABLE AA_UserLog<br /> #Select OK.<br /> #Select Schedules in the left panel.<br /> # Click new.<br /> #* Name : Daily<br /> #* Schedule type : Recurring<br /> #* Frequency : Daily<br /> #* Daily Frequency : Occurs once at : 1:00 AM<br /> #Select OK.<br /> #Select OK.<br /> |-<br /> ! '''Release'''<br /> | Release 7.5(2).<br /> |-<br /> ! '''Associated CDETS #'''<br /> | None.'''<br /> |-<br /> |}<br /> <br /> [[Category:Unified IS, Release 7.5]]</div>

Cchetty