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 );