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

Question

Question

How do I reduce the size of Workflow MDF file?

Workflow
Updated February 1, 2017
asked on February 1, 2017

I have a workflow instance that is using a SQL Express back-end, and I just hit the 10 GB size limit.

 

I've since gone into the WF Admin Console, and changed the Search Instance Lifetime from 30 days to 14 days, and the Reporting Instance Lifetime from 365 days to 180 days.  My question is:  Now that I've done that, how do I get the MDF size to decrease?  I've restarted the Workflow service, but that didn't help.  Do I just have to wait it out?  Or is there some way to trigger the removal of the Search Instance history older than 14 days?

0 0

Answer

SELECTED ANSWER
replied on February 1, 2017

Workflow will run periodic tasks to clear the old data out of the database. Be aware that SQL will not shrink the MDF file on its own, so just looking at the size on disk is misleading. You can use SQL Management Studio to see how much of it is used currently and manually shrink the database.

1 0
replied on February 1, 2017

Thanks Miruna!

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...