How do I maintain more audit history? I created a SQL Server audit and when I view the audit logs I only see today’s audit. I am saving it to a file and I want to store audit for one year. Is there a way to store database and server audit for one year? Does SQL Server store audits for only a day?

CREATE SERVER AUDIT [Audit-20130618-142022] TO FILE 
(
  FILEPATH = N'C:\Documents\Audit\Audit' ,
  MAXSIZE = 0 MB ,
  MAX_ROLLOVER_FILES = 2147483647 ,
  RESERVE_DISK_SPACE = OFF 
) 
WITH 
( 
  QUEUE_DELAY = 1000 ,
  ON_FAILURE = CONTINUE 
);
There is no way to specify the time-span for which audit-files are kept. They are kept based on size and number of rollover files. The old ones will be deleted then. If rollover = 0 and you restart the audit every day, you would only ever have 1 file for example. If you want an "advanced archive mechnanism" you have to store the files elsewhere, i.e. in a special Datawarehouse. (recommended)