Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2011-05-31 : 09:01:42
|
| Due to PCI we have to Enable C2 Audit logging on the SQL server. Last night we had a problem where because it was enabled the audit log was filled up and shut down SQL server. what is the best way to manage the logs? purge? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-01 : 01:36:35
|
| After 200 MB , a new file is created. You could look at monitoring the folder , and transfering the files to a dedicate driveJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-06-02 : 09:19:52
|
| how do i do that? is there a way to shrink the file? i t created 2 200mb files and then there was no space so it restarted |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-06-02 : 09:24:39
|
| how about transferring the files to a database? is that an option? where cna i look? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-03 : 05:24:55
|
| dtrivedi, one way of transfering the file is to use the DOS command MOVE. Place it in a .bat file - and schedule to run regularly. This is a DIY methodJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Enable C2 logging issues