Export current status as Policy - In SQL Server Auditing

• SQListic

  SSCertifiable

  Points: 6904

  More actions

  August 28, 2012 at 2:47 pm

  #266035

  Hi Experts,

  I am going thru enabling the SQL Server audit in 2008R2 for first time, by following this link

  http://blogs.msdn.com/b/manisblog/archive/2008/07/21/sql-server-2008-auditing.aspx

  the part i was unable to understand is "Export current status as Policy "

  what is the use of doing this ?

  why do we need this?

  is this is mandatory?

  Can someone explain advantages in exporting the currents status to policy

  Thanks!

• Randall F Smith

  Grasshopper

  Points: 24

  More actions

  August 28, 2012 at 3:01 pm

  #1531101

  This would make it easier to roll back to your current audit policy, if any. there's also a free audit policy wizard at http://www.logbinder.com/products/logbindersql/resources/wizard.aspx