Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are there different options for SQL Server auditing like writing to database, OS file, system log, etc. and if so what do we recommend?

April 26, 2017Auditing database different file log Options OS SQL Server system writing

0

Posted

Are there different options for SQL Server auditing like writing to database, OS file, system log, etc. and if so what do we recommend?

1 Answer

0

Posted

There are several levels of auditing for SQL Server, depending on government or standards requirements for your installation. You can record server audit action group’s per-instance, and either database audit action groups or database audit actions per database. The audit event will occur every time that the auditable action is encountered. Audit Vault supports SQL Server 2003, 2005, and 2008 C2 auditing, server side trace files, and windows event viewer. For specific information on SQL Server auditing, please check with SQL Server documentation and support.