.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Previous document versions dont seem to disappear after turning off Document Versioning in Doc Libra

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint

We have a two server (WFE + DB) MOSS 2007 installation with MOSS Enterprise version on it.

We had uploaded about 7000 documents amounting to a total of about 2 GB of file size into a document library. We then ran a tool to update several metadata columns for all those 7000 in the library. However we had forgotten to turn off versioning.

This seems to have caused the document library size and thereby the content database size to expand massively and we dont need that to happen. So we turned off the versioning and assumed that the previous versions would be purged by SharePoint and our document library size would reduce back to about 2 GB (total size of the documents uploaded into the library).

However the document library/content database has still not gone down in size. Can anyone suggest any ideas to make SharePoint purge / clean / delete the previous versions for all the documents - The worst part is we dont even see them in the version history anymore, but they seem to be present in the background thereby causing the content database to increase in size significantly.

Please help !



View Complete Post

More Related Resource Links

If you have SharePoint Document Versioning Enabled, do you also use the retention settings?

I am looking for stats on how many environments are out there using document versioning in there libraries but are perhaps not selecting the retention settings. (e.g. "Optionally limit the number of versions to retain" section) This as we all know in SharePoint is a major cause of database growth.
Tony Parker, MSCE . MCTP. MCITP "Anything worth doing, is worth doing right"

Document Versioning

Is there a way to customise the version numbers to depict what department they belong to, such as Engineering will be eng1, eng2, eng3 etc and Logistics could be log1, log2, log3 etc?

Document History Versions

A doc library with turned on function of versioning after any changes of an item. Want to turn it off and delete all history version. This will redeem grand piece of space. Tried to just turn off versioning and free unused space from sql db. Didnt work because all these versions are still there and you can see em after turning version control back. There are over 1k files in a lib and i dont want to manually crawl over each one and cut off these versions.

How to display the number of versions that an item/document currently has?

Hello, If I enable versioning on a list, is there a way to display the number of versions in the version history for each item? Now I have to open the version history for each item to see how many versions there are. I need a quick overview in e.g. the view to see which items contain a lot of versions. Is that possible ?

Event handler to delete minor versions in document libraries

Hi Is there a way we can capture the deletion of minor versions in document libraries using any event handler. May not be using the delete all the minor versions but at least when we use the option to delete the selected minor version. I do not see the ItemUpdating and ItemUpdated getting fired in this case. Thanks wpwije  

Use letters instead of numbers for document versions

Is it possible to use letters instead of numbers for document versions? In sharepoint, drafts are numbered 0.1, 0.2,... 1.1, 1.2, 1.3, etc. and published versions are 1.0, 2.0, etc. But due to company's procedures we should use a different system using letters (A, B, C...). Is that possible? If not, would it be possible to add some property to the documents to add the version letter? I know it may be difficult because the letter can be calculated just after sharepoint assigned the version number... :-(

Users (even site collection administrator) unable to see minor versions in document libraries


I have document libraries with the following settings: major & minor versioning enabled, checkout required & 'only users who can edit items' can see draft (minor) items. The problem is when a user uploads a document (the first document), the library appears empty. However, looking at the summary in 'view all site content' we see that the number of items in the list has incremented by 1. Typically, if the user selects explorer view they can also see the document they just uploaded.

Similar behaviour occurs using the 'New document' option. Before checking in the document for this first time it is visible in the library. If it is checked in as v 0.1 it 'disappears' if it is checked in as v 1.0 it is visible.

I have noticed that if I toggle the Draft Item Security setting by setting it to 'any user who can read items' then set it back immediately to 'only users who can edit items' that the previously hidden items become visible. And any new minor versions created subsequently are also displayed correctly. I can of course do this for existing libraries, but if new libraries are created based on my template this behaviour reoccurs.

Has anyone seen this before?

How do I move a document library, with versioning, from one website to another.

How do I move a document library, with it's versioning, from one web site to another in MOSS 2007?

Help needed in versioning through code in document library?



I have a situation where i need to move the document form one library(LB1) to another library (LB2) thorugh event handler code. For documents which are not available in LB2 it is working fine but a case where document is already existing in LB2 i need to maintain the version instead , whereas my code is replacing the document already present.

Can anybody help me getting the versioning done through code?


Many Thanks



View previous version of a file in document library using Client Object Model




Using Server-side object model, it is pretty simple to get the previous file versions. Say I wanted to view a file in its initial version, all I’d need to do is :




When using Client object model, I couldn’t any analogous method/property which would let me fetch the previous version of file.

Can somebody point me to a sample or the property which would serve my purpose?

How to Set System.Windows.Controls.WebBrowser.Document Property , navigatetostring,stream DONT WORK


Hi , i search in google , bing , cuil and all of searchs provider for the solution of this problem :


I get HTML content from HTTPWebRequest(because is much requests and if i use WebBrowser control directly i get a lag and video processing unnecessary)


And i need  set System.Windows.Controls.WebBrowser.Document with this text.


"Solution" , use new methods call NavigateToString() or NavigateToStream()

BUT THIS PROBLEM , both DON'T work with <javascript src="something.js"> or <style src="something.css">

Navigates ONLY read and process content INSIDE this tags , no external files (like 'something.js')

Solution i encountred after two weeks of search

Process the text and replace the files by the content of that.

But this i think that is no real solution. (i tested , work , but not perfectly) * I write my own code because that post dont have source code.

for why you need to do that?

because i need interact with users after search , and use html's input to re-search again and process this file with all extern files is too slow

Any solutions?

C# Lenguage

Sorry for bad english, i'am brazilian.


Restore a previous version of a document in a document library - error

  When I try to restore a previous version of a document in a document library, I get this error message:

"Updates are currently disallowed on GET requests. To allow updates on a GET, set the AllowUnsafeUpdates' property on SPWeb"

I am NOT running any custom code anywhere on my SharePoint site 

SharePoint Document Library - Compare two versions - blackline


Autonomy WorkSite has a capability called iManage that allows a user to select two documents and view the blackline / redline version of the document hightlighting the differences between the two documents.  Does anyone know if this capability has been extended into SharePoint? 

I know I can perform this function from the Compare button on the Review tab of Microsoft Word 2010, but I am interested in performing this capability right from SharePoint.

Thanks in advance!


Move document (and versions) from one library and/or site to another?


I may be at searches, but I couldn't find anything related to this... Honest, I looked!


Is there a way to move a file from library to library and make sure that the versions make the trip also?


Any help is appreciated.  Thanks!

files dont apper in document libary


in windows sharepoint server 2007 when i create word file in document libary after i created it

file dont appear in list

Why disappear permissions of document folder?



I have problem with permissions of document folder. Laws disappear from time to time and I don´t know why it happen.

It is happening by folder, wich is divided to several subfolder. For example: folder1/folder2/folder3


folder1 is document library, where is set up, that users from group "reading" have permission for reading this folder.

folder2 inherit laws from folder1

folder3 - permissions for this folder are withdrawal from group "reading" and to this folder is added user with permission for reading and contribution.


Problem is that from time to time folder1 loses permissin for group "reading" and at the same time folder3 loses permission for user, who can contribute in folder3.

Users for the folder3 we add, this is not inherit from folder2. I cannot find why disappear permissions for users, who we add.

We use Sharepoint Services 3.0

Thank you for your help!

How to delete document versions in sharepoint 2007



i want to delete document versions from all document libraries in a site collection.

i know we can restrict versions at a document library level , do we have such thing at site collection level?


Thanks In Advance



Share Knowledge and Spread Love!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend