Question

Can the Audit Trail MDF file have an age limit?

Audit Trail

Updated March 4, 2014

asked on March 3, 2014

We have an issue with Audit Trail's SQL DB becoming to large and growing at a exceedingly rapid pace. Is there a way to put an age limit on what is kept in the SQL DB?

0 0

Answer

SELECTED ANSWER

replied on March 4, 2014

Audit Trail is configured for a default period of 30 days. I wonder if by "SQL DB" Amanda is including all the database space, including the logs.

It's very common for people to create a database and leave it in "Full" recovery mode rather than "Simple" "Full" causes the log file of the database to grow indefinitely until it's backed-up or truncated. If that's the case, it's easy to set the database to Simple mode and shrink the log file.

You could check out this page, for example: http://blog.sqlauthority.com/2010/05/03/sql-server-shrinkfile-and-truncate-log-file-in-sql-server-2008/

-Ben

0 0

Replies

replied on March 3, 2014

You can use the configuration pages to control what is loaded in the reporting database. One of the options is to specify the last x days, which is what it sounds like you want.

1 0

You are not allowed to follow up in this post.

Question

Question

Can the Audit Trail MDF file have an age limit?

Answer

Replies

Sign in to reply to this post.