© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
J. BushPractical Database Auditing for Microsoft SQL Server and Azure SQLhttps://doi.org/10.1007/978-1-4842-8634-0_11

11. Centralizing Audit Data

Josephine Bush1  
(1)
Boulder, CO, USA
 

An important part of auditing is being able to easily query and report on multiple servers’ audit data. In this chapter, you will learn how to centralize audit data with SQL Server Agent and linked servers. You will also learn how to set up audits on multiple servers with a registered servers list.

To centralize audit data, you will need these items:

  • Centralized audit database – This is used to store the auditing data from all the audited servers.

  • Auditing user on the central ...

Get Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial