Answer Detail: RE: Purge Data

GeekInterview.com > Interview Questions > Database > Sybase

Print |

Question: Purge Data

Answer: How will you purge data from audit database?

June 06, 2009 07:43:40	#1
mikeob	Member Since: June 2009 Total Comments: 6
RE: Purge Data
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.