mikeob

 Profile Answers by mikeob 

• Jun 17th, 2009

 

To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get the data into a more persistent location. From there you can either use normal dumps, tran dumps or pipe/filter the transaction data using a stored proc, ETL, etc etc.