28. November 2015 01:24
I just got a production database. This database was massive. One of the big tables was the cmsPreviewXml.
To clean up the Umbraco cmsPreviewXml run the SQL script below. This will delete all older previews, but keep the most recent.
where versionId in (
from cmsPreviewXml join cmsDocument on cmsPreviewXml.versionId=cmsDocument.versionId
where cmsDocument.newest <> 1)
The other scripts I used to clean the umbraco database are in this gist: https://gist.github.com/dampee/a8ead728165b16d49c00