From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create an audit on SQL Server

Create an audit on SQL Server - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Create an audit on SQL Server

“

- [Instructor] Creating an audit using T SQL commands can be straightforward if you just need the standard configuration. There are a lot of options though. So the statement can get much longer in which case the graphical user interface provided by management studio might be a better option, but let's see what a basic set up looks like in a new query window first. To create a server audit, we first need to switch into the master database then we'll create the new server audit with the lines create server audit and then the name of the audit. I'm going to choose to save this audit in a file in a folder that I've already created on my C drive called TempSQL. I can set the maximum file size allowed by the audit, here I've got it capped at 10 megabytes. You can specify any amount from two megabytes to two terabytes just notice whether you're using MB for megabytes, GB for gigabytes, or TB for terabytes. You can also set the max size to unlimited if you wanted to in order to allow the…

Contents