Community

Steps to restore a database that has a SQL Server Audit defined

(Matteo Lorini) When restoring a database, that has audit specifications defined, on a different server, the audit events are defined but the audit mechanism is not able to capture audit data. In this tip we walk through the steps you need to take to enable capturing of audit data for the database.

Read More - Register for Free Membership