SQL Server Audit Action Group: BACKUP_RESTORE_GROUP

This group tracks the backup and restore of databases and transaction logs. This group is important to enable so that you have an audit trail of database backups which could be used to steal entire copies of a confidential database. And of course an inappropriate restore of a database could have disastrous effects.

If you enable this group on the server it will track backup and restore operations on all database and send transaction logs. To only track such operations on one database enable this group in a database audit specification on that database.

LOGbinder for SQL Server events generated under this Audit Action Group:

Event ID	Description
24024	Issued database backup command
24025	Issued transaction log backup command
24026	Issued database restore command
24027	Issued transaction log restore command

 

Upcoming Webinars Unpacking a Linux Supply Chain Compromise Using the Recently Published XZ Utils Backdoor as the Example Assessing the Security of Your Active Directory: User Accounts Anatomy of a Cloud Hack: The Cloudflare/Okta Compromise – A Story of Tokens, Lateral Movement, Persistence and the Salvation of Zero Trust and Hard MFA Tokens

Additional Resources

•	Server Audit Specification
•	Database Audit Specification
•	Audit Action Groups
•	Audit Actions
•	Audit Policy Wizard