WF Persistence - remove old workflows

Question

When using Workflow Foundation with persistence there comes a point we want to drop some (or all) workflows out of it which no longer should be persisted/run.

Any script/tool that I can use for this?

Answer 1

There is no standard WF tool you can use to do this. The best way is just go into the persistence database through some custom command line tool and remove them. The SqlWorkflowPersistenceService isn't any help because you have to start the WF runtime before you can use it to retrieve workflows and they would also be able to start running.