I have workflow history for sharepoint list which has almost more than 100 millions of items(around 32GB for workflow history) This WF history list makes problem when I tried to connect SPD to clear this list.
(Just FYI- I checked timer job named “Workflow auto cleanup” for web application, is working fine. but still in sharepoint workflow history list has almost 30GB, which is 100's of million records.
I am trying to delete list items using power shell script but it will takes almost 3-4 months of time.
Is there any other solution that I can clear workflow history quickly?
@Sravani Muttineni In my experience (SP2013 though), I never bothered trying to clean it up. For large active lists I'd go into SPD every year and change the workflow to 'New History List' and republish. That will give you a new empty list. If I didn't need the old information, then I'd delete the old list.
@Robin Nilsson I had a plan to delete that list but I couldn't delete that list too, tried in SPD. So I create new history list and republished already. I have to clear this workflow history because it is occupying lot of space in DB,especially for all users data, all docs , Docs Stream and storage metric tables. Our Content DB size is now 891195.38 MB.
That's way I am looking any other solution to clear WF history list. Thanks!