Thursday, January 17, 2013

SharePoint Versioning Manager - Control Versioning Settings & Clean Up Old Versions

We have document libraries with unlimited versioning enabled for years. As part of regular auditing Version History Size Report for Entire SharePoint Web Application , found many documents have more than 100 versions!  In order to free up more database storage space and for better performance, We understand that we'll have to disable or limit versions.

Although, versions are very useful to track changes, each of the versions is a copy of the document and takes up a disk space (Till SharePoint 2010, BTW). As per Microsoft design changing versioning limits will not delete existing minor/major versions of the file until we update it.

Its a best practice to limit versions. You can Navigate to Document Library Settings >> Version Settings >> and set versioning limits, set versioning ON/OFF in SharePoint versioning settings page. But this will not have any effect on existing documents until you make edits on the document and update. (You can Check-out and check-in them back as a Shortcut). Also its not possible to get into each document library and set these settings manually, isn't it? As there were thousands of files in the document library I would like to programmatically approach the change to simply get rid of the old versions across the site and regain space.

PowerShell can Set Versioning Limits and Cleanup Old Versions:
All of these issues can resolved with a powershell script which does clean up of old versions in SharePoint library by looping through all the site collections, webs, lists and items. From each item it checks the versions and delete. Take a look at my post: Limit and Cleanup Versioning in SharePoint with PowerShell

SharePoint SharePoint doesn't enable versioning by default!
However, not all SharePoint guys are good at PowerShell scripting (You must be good at PowerShell, SharePoint Admins!) and obviously its easy to make disaster if you are novice! So, would like to have a GUI based SharePoint utility to fix versioning of document libraries.

SharePoint Versioning Manager Utility to Set Limits and Cleanup Old Versions
I've created a SharePoint tool using C# object model, which gives the functionality to manage document versions and  programmatically remove extraneous versions either for a selected list or library or of all lists and libraries in a SharePoint site. It takes parameters such as:
  • Site collection URL, Site
  • List/Library (or All List & Libraries)
  • Define Version limits (No. of major versions / No. of minor versions to keep)
  • Turn OFF/Turn ON versioning for selected or all lists/libraries.
and perform desired operations. Here are some screen shots of SharePoint Versioning Manager in action.
This utility is built on SharePoint server object model and must be running from SharePoint Web Front End Servers! Not from your desktop!!
Get Versioning Analysis of all document libraries and lists:
Tool to Analyze sharepoint versioning Settings
Analyze Versionings of a Selected Library:Reduce sharepoint versioning to get storage space
Set Versioning Limit and Cleanup for a Selected Library:
SharePoint Versioning Manager - Control and Clean Up Old Versions Set the versioning limits either for selected list/library or for entire site.
Tool to Trim and Cleanup SharePoint Versions
 In a Project collaboration environment, with this utility, We had a doc library setup with versioning 5 major and 5 minor. we recovered about to 28 GB of free space!

Download: SharePoint Versioning Manager from CodePlex

Versioning Manager for SharePoint 2013 released at: https://versioningmanager.codeplex.com/releases/view/612871

As always, I see there are room for enhancements to the tool, will update and release a new version as and when time allows!



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

8 comments :

  1. Hi Salaudeen, Thanks for this.
    I had several lists with problems around the enormous amount of versions (someone created a workflow that looped, which on a list with unlimited versioning... well ) I could not even delete the list because the server ran out of resources.

    Your tool helped me a lot to clean this mess up, many thanks for that!
    a

    ReplyDelete
  2. Saludeen -

    Is there a way to run this utility on an automated, command-line basis? I have a long list of sites that I need to run analysis reports on. Your initial code is great, but I'd hate to re-invent the wheel and write a new utility to export CSVs/Excel Spreadhseets when yours already does that.

    Thank you,
    Larry

    ReplyDelete
    Replies
    1. Larry,

      This utility written in .Net WinForms! If you are looking for automation: PowerShell scripts on this blog can help.

      Delete
  3. Will this work with SharePoint 2013?

    ReplyDelete
  4. Need SP 2013 Version. Can you assist?

    ReplyDelete
    Replies
    1. Thanks, Salaudeen -- this worked well for me. Do you plan to have the source code released for this tool?

      Delete
  5. Demo-ing now and this tool is working great! Much appreciated

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...