We have enabled SQL Server Query auditing with ‘On Audit Log Failure’ set to Continue, so not to lock up the system.   I would like to setup a SQL Server Agent Alert that would fire when the Drive is full and it is not able to write the audit to the file.  

Any help?

​We have enabled SQL Server Query auditing with ‘On Audit Log Failure’ set to Continue, so not to lock up the system.   I would like to setup a SQL Server Agent Alert that would fire when the Drive is full and it is not able to write the audit to the file.   Any help?  Read More

​