Audit tasks

• river1

  SSC-Insane

  Points: 24309

  More actions

  November 14, 2013 at 4:36 am

  #300258

  Hi,

  I want to create a database that log into a table this type of operations:

  1) t-SQL script passed againt the database

  2) Backups made

  3) Retores made

  This database will have a table and everytime someone makes a backup of any of the databases that are on the SQL Server instance or a restore or a t-sql script, the instance will log inbto this table of this database.

  Is this possbile?

  What about the t-sql script, can I log it's SQL into the table?

  Thanks,

  Pedro

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  November 18, 2013 at 2:19 am

  #1667051

  Backups and restores are already logged in msdb.

  http://technet.microsoft.com/en-us/library/ms188062.aspx.

  You can run a server side trace to capture sql statements executed on an instance.

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]