SharePoint 2010: Strategies for Handling Historical Data in Custom Lists

SharePoint 2010: Strategies for Handling Historical Data in Custom Lists

This Wiki page discusses strategies for dealing with historical data. It was originally inspired by Paul Stork's response at http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/31cf9e61-4faf-4832-aefc-a110d7d93ad2.

  • If the historical data doesn’t take up much space, leave it in the original list.
  • Turn on versioning if you want to track the history of individual list items.
  • If the history involves different records, leave them in the list and sort the view on the date of the history with the most recent at the top.

Finally, the most common option: eventually archive the items to a different site collection in a different content database if you need to save space.

Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 1. Comment: Title casing and tags

  • Paul stork edited Original. Comment: No real need to archive to a different list if space isn't an issue.

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Paul stork edited Original. Comment: No real need to archive to a different list if space isn't an issue.

  • Ed Price - MSFT edited Revision 1. Comment: Title casing and tags

  • Very Helpful knowledge!!

Page 1 of 1 (3 items)