Prowatch - TRUNCATE TABLES
Posted: Tue Nov 10, 2009 4:20 pm
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
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