Prowatch - TRUNCATE TABLES

ProWatch, PW5000, PW6000
Post Reply
Leo
Site Admin
Posts: 889
Joined: Thu Dec 11, 2008 7:52 am

Prowatch - TRUNCATE TABLES

Post by Leo »

This we delete the 3 tables in prowatch that can grow out of control.

Do a backup before doing this and then after and look at the size of the backups

Click on Database Manager
Click Query Analyzer
Type -
TRUNCATE TABLE EV_LOG
TRUNCATE TABLE UNACK_AL
TRUNCATE TABLE AUDIT_LOG
EXECUTE


This will delete the 3 log files, MSDE is only good to 2gig total
Post Reply