We have a Sitecore 8.1.1 with Sharepoint Connector 2.1. the connector imports 4000 documents from the Sharepoint (max 10 GB). The problem is that the Blob Tables last time were more than 80 Gb on master and web.
we did CleanUp using the the Sql Query to delete the Blobs, not connected with any item.
USE [Sitecore_web] GO /****** Object: Table [dbo].[Blobs] Script Date: 24/07/2017 16:41:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO delete from Blobs where BlobId NOT IN ( Select Value from SharedFields with (nolock) where FieldId = '40E50ED9-BA07-4702-992E-A912738D32DC' and Value != '' Union Select Value from VersionedFields with (nolock) where FieldId = 'DBBE7D99-1388-4357-BB34-AD71EDF18ED3' Union Select Value from ArchivedFields with (nolock) where FieldId in ('40E50ED9-BA07-4702-992E-A912738D32DC','DBBE7D99-1388-4357-BB34-AD71EDF18ED3') ) GO
But in three weeks the blobs Tables are big again and there are almost 19000 extra files.
Any idea why Sitecore doesn't do CleanUp?