Keeping Historical Data in Custom Lists RRS feed

  • Question

  • I have a very practical question for those who have used custom Lists in SharePoint for real things (like Purchase Orders or Leave Applications).

    What do you do with historical data?  Do you leave it there and make sure that the Views you use only display the Items you want?  Or, do you move all records older than a certain limit to a "History" List, and allow users to look up either List?

    Wednesday, March 7, 2012 2:01 PM


  • If its not an issue of space in the content database then I would leave the historical data in the original list.  If its history on individual list items then capture that by turning on versions.  If its history involving different records then leave it in the list and sort the view on the date of the history with the most recent at the top. 

    If it is an issue of space in the content database then I would suggest archiving the items to a different site collection in a different content database.  Just moving them to a different list won't help with space issues.

    Paul Stork SharePoint Server
    MVP Chief SharePoint Architect: Sharesquared
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    • Proposed as answer by Margriet Bruggeman Wednesday, March 7, 2012 3:49 PM
    • Marked as answer by Entan Ming Thursday, March 15, 2012 10:59 AM
    Wednesday, March 7, 2012 2:14 PM

All replies