SQL Server runs out of disk space while using bv-Admin for Windows Audit Log Consolidator (ALC)
|Article:TECH113740|||||Created: 2007-01-13|||||Updated: 2008-01-10|||||Article URL http://www.symantec.com/docs/TECH113740|
The Microsoft SQL Server database files have grown several gigabytes in space on the bv-Admin for Windows server.
- Errors appear in the event log from the Microsoft Operating System that the hard drive is full.
The ALC is not cleaning out the old Event Viewer content data that is collected.
Follow these steps to resolve the issue:
1. Make a full backup of the database to another server where data can be collected from the Event Viewer table.
2. Login to Enterprise SQL Manager, then remove all rows from the ALC Event Viewer table.
3. In the ALC Configuration, configure the settings for how long to keep data in the Main ALC database and how long to keep data in the Archive ALC database before deleting.
WARNING: If there is no setting for removing data in the Archive database or moving from the Main ALC database to the Archive ALC database, then the hard drive will fill up again.
4. Click Start | Accessories | System Tools | Scheduled Tasks. Schedule the bv-Admin Audit Log Archive Manager to run on a daily basis.
This ensures that older logs are moved to the Archive ALC database and old logs within the Archive ALC database are deleted.
Article URL http://www.symantec.com/docs/TECH113740