Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › SQL Server 2008 Audit Specifications › Define a SQL Server 2008 Server Audit

Define a SQL Server 2008 Server Audit

Use the SQL Server Server Audit Editor in a SQL Server 2008 physical model to define the actions on the server to audit and for whom, and the physical file used to contain the audit data.

To define a SQL Server 2008 server audit

1. Click Target - SQL Server, Server, Audits on the Model menu.

   The SQL Server Server Audit Editor opens.

2. Select the server audit in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new server audit. Use the Enter filter text box to filter a very large list of server audits to quickly locate the one that you want to define.

   Name

   Specifies the name of the server audit. You can change the name of the server audit in this field.

   Type

   Specifies the location for the audit trail. Select File, Application Log, or Security Log from the drop-down.

   Enabled

   Specifies the status of the audit.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:

   Audit Options

   Lets you specify the following options for the server audit:

   Queue Delay

   Specifies the maximum time to wait, in milliseconds, before writing audit information to disk. Enter a value in this field.

   Failure Action

   Specifies the action to take upon failure to write an audit entry. Select an action from the drop-down.

   Audit GUID

   Specifies the GUID for the audit on a mirrored database. Enter the GUID in this field.

   Audit File Options

   Lets you specify the following options for the audit file.

   Note: These options are available only if the server audit type is File, as specified in the Navigation Grid.

   File Path

   Specifies the location of the audit file. Enter the location in this field

   Max Size

   Specifies the maximum size of the audit file. Enter a value in this field.

   Maximum Rollover Files

   Specifies the maximum number of audit files to retain. Enter a value in this field.

   Reserve Disk Space

   Specifies if disk space should be preallocated. Select an option from the drop-down.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the server audit.
5. (Optional) Click the Where Used tab to view where the server audit is used in the model.
6. (Optional) Click the UDP tab to work with user-defined properties for the server audit.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The server audit is defined and the SQL Server Server Audit Editor closes.