Archiving your SharePoint workflow history lists

I found a good article to archive SharePoint history list using SSIS package.

http://whitepages.unlimitedviz.com/2011/09/archiving-your-sharepoint-workflow-history-lists/

Comments

Post a Comment

Popular posts from this blog

Switch from Classic to Claims Authentication in SharePoint 2010

SharePoint 2013 tutorials, SharePoint 2010 articles, SharePoint interview questions: Switch from Classic to Claims Authentication in Sh... : In this article we will discuss how to switch from Classic Mode Authentication to Claims Authentication. $webApp = Get-SPWebApplication “http://web application URL/” $webApp.UseClaimsAuthentication = 1 $webApp.Update() $webApp.ProvisionGlobally() $webApp.MigrateUsers($True)
Read more

Reset List Item ID value numbering at 1

One of the most common problem we face in SharePoint Lists is there is no direct option to reset the value of ListItem ID. In development environment we used to insert and delete lot of test records and during this time ID value automatically increased since ID column is a incrementer type. Finally when we move the site to staging and production environments using backup and restore the ListItem ID value will not start with 1. But we do not have a OOB option to reset this value. But in the backend content database we can reset this value for any list. The following query will be used to reset value. UPDATE < Content DB >.dbo.AllListsAux set NextAvailableId=1 where ListID='< GUID >' Here you can see a table called AllListsAux . This list maintans Item count and Id details for all lists. Please note we have to be very careful while doing any opertation in backend. Hope you like this post. :)
Read more