A common question I receive is that the production database gets bigger and bigger when duing SiteDeployment imports although items are only updated and no new items are added.
The reason for this is that during import a new historical revision will be created for all updated items. If you have frequent update this can cause a significant grow for the database. To reduce this it is required to clear the revision history on the production system.
Unfortuantelly this can only be done using Site Manager and not using script. So it is required to have at least one read-write web site on a MCMS server that is connected to the production database to allow Site Manager to connect to the server to clear the revision history.
If this has never been done before clearing the revision history can be a very time consuming job that can take several hours. In addition the MCMS server doing this job is running on high CPU till the revision history has been cleared. To address this Microsoft created an KB article with instructions on how to replace the stored procedure responsible for clearing the revision history with a more efficient version:
I have CMS 2001 and have been trying to reduce the DB size via the Purge Revisions option under Tools in Site Builder.
It seems to successfully complete, but then when I go to shrink the DB, its size does not change, and if I look at the files they still seem to have the revisions.
My development DB is now about 2 GB but the production is up to 50 GB now! So I am desperately trying to get back my valuable disk space. (I just found this out a few days agao)
Do you know any fixes for this?!!
I assume this will help: