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

Question

Question

LF_workflow_CRD.mdf has grown to over 300GB

Workflow Version 10 Administration
Updated April 28, 2017
asked on April 28, 2017

Greetings,

Due to a runaway workflow LF_workflow_CRD.mdf has grown to over 300GB in size. I was alerted only to this when our disk space on our SQL server reached <5% free. The process was stopped and it is not growing but how do I shrink this file? I have gone into workflow administration\Advanced server options\Maintenance and changed all lifetimes to 1 day also I have changed the log files to delete after 1 day. This happened 3 days ago but whenever I run the Shrink command through SQL Server Mgmt Studio on this database it only reports minimal Space available.

Two questions: How do I shrink this database? If a workflow errors out what is the best way of stopping automatically? When this workflow typically fires it is done in less than a minute.

 

Thx.

0 0

Replies

replied on April 28, 2017

Easiest thing to do in this case is contact your VAR and ask them to get in touch with Laserfiche Support. Laserfiche can provide a Workflow Database Cleaner utility, which will clear out data from the SQL tables for a given workflow, and within a given date range. After that, you should be able to shrink down to a normal size.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...