You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives
according to the following table:
You discover that the Windows application log is being filled with entries from a SQL Server
Audit process named DatabaseAudit. The volume of these events is causing older events to
be removed from the log.
You need to ensure that the following requirements are met:
-SQL Server Audit information is stored in the D:\AuditLogs folder. -No data is currently lost
in the Windows application log.
What should you do?
A.
• Open the Windows Server Manager.
• Browse to the Diagnostics\Event Viewer\Windows Logs folder.
• Right-click Application Log, and then click Properties
• Enable the Clear Log option.
B.
• Create a folder named AuditLogs on drive D.
• Run the following Transact-SQL statement:
ALTER DATABASE Dat3baseAudit
ADD LOG FILE (NAME = DatabaseAuditLog, FILENAME =
‘D:\AuditLogs\DatabaseAuditLog.Idf)
C.
• Create a folder named AuditLogs on drive D.
• Run the following Transact-SQL statement:
ALTER SERVER AUDIT DatabaseAudit
TO FILE (FILEPATH = ‘D:\AuditLogs’)
D.
• Open the Windows Server Manager.
• Browse to the Diagnostics\Event Viewer\Windows Logs folder.
• Right-click Application Log, and then click Properties.
• Enable the Do not overwrite events (Clear logs manually) option,