June 22, 2016 at 7:24 am
I'm required to run a SQL Audit (or a SQL Trace, I've switched to Audit) *and* I'm required to have "an automated system to centrally manage and offload" the audits to.
So, the question is, is there any way to do this, whether natively in SQL Server (such as copying the Audit files to another server via a scheduled job, then importing those files into a SQL instance there,) or a third-party product that can do something similar?
I'm currently looking at the pages for Idera SQL Compliance Manager, which looks like it might do what I'm needing (time to try to the trial on my home lab,) although it's hard to tell if it's using SQL Audit behind the scenes (which would make it far easier to show that it satisfies the requirements of what I need to audit.)
Are there any other suggestions you can make?
Thanks,
Jason A.
June 22, 2016 at 12:16 pm
So, from what I found in the Idera documentation, it uses SQL Trace to collect its information. While I can meet the requirements with Trace, I'd much rather stick with Audits...
Still looking...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply