You are viewing limited content. For full access, please sign in.

Question

Question

Does AuditTrail 9.1.1.automatically shrink SQL DBs?

Audit Trail
Updated April 29, 2019
asked on April 4, 2014

Our DBAs report that they are seeing shrink commands for each of the audit trail DBs even though they are using the full recovery model. Are shrink commands automatically issued as a part of audit trail? If so, is this a setting that can be disabled?

 

Our DBA is reluctant to use regular DB shrinking due to potential DB fragmentation on disk.

 

 

0 0

Replies

replied on April 4, 2014

It does shrink the database after deleting rows.  There isn't currently an option to turn this off, but that is a good idea for a future version.

1 0
replied on February 7, 2018

Brian,

This post was from 2014.  I was wondering if this has been addressed with newer versions of Laserfiche?  My DBA brought the same issue to me; he is worried about the fragmentation of the database and potential performance issues.

 

Thanks,

Jonathan

0 0
replied on April 25, 2019

Any update on this? My client's DB admin is also concerned with the shrink task as it has been running the shrink command for over 8 hours now.

0 0
replied on April 29, 2019

Starting with version 10 of Audit Trail, this is a configurable setting.  I don't think there's a UI to turn it off, but the config.xml file has a line: 

<Maintenance AutoShrink="true" />

You can change the value to false and restart the service.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...