Voltar
-
Título
"RESTORE VERIFYONLY" and "RESTORE LABELONLY" are captured as DDL operations (CREATE DATABASE) when using SQL Audit and Extended event data collection -
Descrição
RESTORE statements are collected for auditing even when Backup/Restore filter is not selected
-
Resolução
Expected result: The mentioned RESTORE statements should not be collected for auditing if the Backup/Restore filter is not selected.
WORKAROUND:
1. The RESTORE statement can be excluded through the advanced filter
For more information on using the ApexSQL Audit advanced filters please check the Advanced SQL auditing filters
2. Switching data collection to Trace
STATUS
Waiting for fix in future release of ApexSQL Audit
DEFECT ID
225105