Answered by:
SharePoint 2007 : Versioning

Question
-
Hi All,
I had a simple question, I got a SharePoint 2007 publishing page, it is frequently check out and published. Therefore, the number of version keep increasing, so is there any drawback if the page visioning keep growing ( greater than 200)?
what is the maximum version number for SharePoint 2007 publishing page can go? and how SharePoint handing visioning?
thank you in advanced.
Tuesday, November 8, 2011 2:21 AM
Answers
-
Hi,
If you store many versions then it will fill up the content DB space.
Also if you try to copy page at other locations and will export the site taking all versions you will find that it will generate long running queries and also will take much time and will impact your performance.
Hence I would suggest you to have a limited number of versions only.
I hope this will help you out.
Thanks, Rahul Rashu- Marked as answer by sams371 Wednesday, November 9, 2011 8:48 AM
Wednesday, November 9, 2011 8:34 AM
All replies
-
May be following links will help you:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-versioning-HA010021576.aspx
http://weblogs.asp.net/jan/archive/2006/05/09/445875.aspx
http://stackoverflow.com/questions/4491089/moss-2007-version-history-query
http://geekswithblogs.net/stephaniegrima/archive/2008/09/02/versioning-sharepoint-version-management.aspx
Thanks, Amit Kumar, LinkedIn Profile ** My BlogTuesday, November 8, 2011 6:38 AM -
SharePoint uses a 32 bit number to store the version information. The lower 9 bit are used for the minor version. So you can have up to 511 minor versions.
The rest of the bits (23) are used for the major version.
So that should give you 2^23 = 8388608 major versions.
Stefan Goßner
Senior Escalation Engineer - Microsoft CSS
This post is provided "AS IS" with no warrenties and confers no rights.Tuesday, November 8, 2011 9:49 AM -
Hi Stefan Goßner, thank you for your reply, since SharePoint can stored up to large number of major version, is there any drawback if the version keep growing?Wednesday, November 9, 2011 2:38 AM
-
Hi,
If you store many versions then it will fill up the content DB space.
Also if you try to copy page at other locations and will export the site taking all versions you will find that it will generate long running queries and also will take much time and will impact your performance.
Hence I would suggest you to have a limited number of versions only.
I hope this will help you out.
Thanks, Rahul Rashu- Marked as answer by sams371 Wednesday, November 9, 2011 8:48 AM
Wednesday, November 9, 2011 8:34 AM -
Delete the older version if not needed for feature.
anil, Mark as Answer if it helps..Wednesday, November 9, 2011 9:57 AM -
Ya, should delete older version, but it is delete 1 by 1, is there anyway to perform mass deleting?Monday, November 14, 2011 9:25 AM