Sharepoint versions explained
To specify the number of major versions of files that are stored, select the Keep the following number of major versions check box, and then type the number of major versions that you want to keep.
To specify the number of major versions to keep the drafts for, select the Keep drafts for the following number of major versions check box, and then type of the number of major versions that you want to keep drafts (minor versions) for.
Lots of customer thinks second box it to specify the number of minor versions. But in actual second box is to specify how many major version can have minor versions.
By default, each major version can have up to 511 drafts (minor versions).
If a list or library limits the number of major versions, the earliest versions are deleted when the limit is reached.
If your limits the number of versions that it stores, the oldest versions are permanently deleted when the limit is reached. They are not sent to the Recycle Bin.
If disabled versions to fix space issues on server. Please always have a look to recycle bin at both level.
Tables in version.
Basically there are three table AllDocs, AllDocStreams and AllDocVersions for managing the documents uploaded in the sharepoint site.
AllDocs will have document information.
AllDocStreams table will always have the latest version of the document in the Content column.
6In 2.0 there was a single table called "Docs" that stored all of the Document info on a site, including the document itself (which is an "image" (binary) field called "content").
AllDocVersions table will have all the versions of the document.
AllDocs.
It only contain document details
AlldocStreams
It contain actual content.
Level
1 |
The default value, referring to a published document shown to all users who have access to its storage location. |
2 |
This document is in a draft state and should only be shown to users who have permissions to see documents in a draft state. |
255 |
This document is checked out to a particular user and should only be shown to that user. |
AllDocVersions
It contains all the versions of documents.
There may be scenario where you can have more than one document in AlldocStreams . This happens if we have unpublished versions of that document.
1 |
The default value, referring to a published document shown to all users who have access to its storage location. |
2 |
This document is in a draft state and should only be shown to users who have permissions to see documents in a draft state. |