From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
SQL Server audits - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
SQL Server audits
- [Narrator] Auditing on a SQL Server instance is an important task that helps guide the focus of the server administrator and can point out areas that can be improved, the cause of functions that aren't quite working as intended, or simply monitoring activity for compliance with government or industry policies. At its core, an audit simply logs events that are happening on the server instance or in a database and saves them out as audit files that can be reviewed after the fact. To begin, you'll need to create a SQL Server audit. This is the main container object that will hold components and assemble the final audit documents in a location called the audit destination. This is where SQL Server will store the results of the audit once it's enabled and can be either files on disk, written directly to the Windows Security event log, or the Windows Application event log. Once the SQL Server audit is created, you'll need to decide what specifically that you want to keep track of. This is…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.