LINKS
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs 
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.
|
ApexSQL Knowledgebase Tips and How-to Articles for Apex SQL Tools How to Delete Old Data in Audit tables DESCRIPTION ApexSQL Audit stores audit data in SQL Server tables. These tables can be installed in the same database being audited or in a different database on the same server. These tables can be queried via SQL or other data access tools. The tables included in the default architecture are: AUDIT_LOG_DATA and AUDIT_LOG_TRANSACTIONS. This article discusses how to delete data in these tables as they grow. SOLUTION 1) From the Outlook Bar, click Manage Audit Data.  2) The Manage Data dialog is displayed.  The following delete options are available: a) Option 1: I want to delete all data now. This option truncates the data from your Audit tables when you click the Delete All button. b) Option 2: I want to delete data now based on Data Deletion Criteria below. This option allows you to specify a deletion criteria.  Deletion criteria can be any of the following: -by Age (e.g. Delete data older than one month) -by Log size (e.g. Delete 30 rows of data) -Delete All Data (same as Option 1) To perform deletion based on the criteria you set, click Run Task Now. c) Option 3: I want to Create and Schedule a Job to Delete Data Later Based on Data Deletion Criteria Below This option allows you to create a scheduled job to run your Data Deletion task on a schedule. Provide a Job Name and specify your deletion criteria. Next, click Create DTS job or Schedule. Below dialog appears:  SEE ALSO Manage Audit Data AUTHOR Janice Lee LAST REVIEW DATE 21 August 2007 Labels: Apex SQL Audit |
© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy