Hi Alex,

Thanks for your time! :)

I will try run that script, currently i have tried this one,

https://gist.github.com/genckastrati/0e7f7ae6156647e00a56eb5ef403166d

But it didn't allowed me to empty the recycle bins :(

Thanks for sharing this!

I noticed some errors related to cmsContent what was about to be deleted but had a foreign key constrain to a media item, after emptying the media recycle bin from the backoffice this code worked great on Umbraco v7.12.3.

Edit: Also for 7.8+ the umbracoUser2NodePermission-row can be changed to

DELETE FROM umbracoUserGroup2NodePermission WHERE nodeId IN (SELECT id FROM umbracoNode WHERE (path LIKE '%-21%' AND id!=-21) OR (path LIKE '%-20%' AND id!=-20));

// m

Is this script working for the latest Umbraco version?

Here's a version that I use for v8.

BEGIN TRAN

-- I recommend figuring out what is causing any constraint issues instead of turning the constraint off, but thought I'd include it.  
--ALTER TABLE umbracoNode NOCHECK CONSTRAINT FK_umbracoNode_umbracoNode_id

DECLARE @Nodes TABLE (NodeId int)

INSERT INTO @Nodes (NodeId)
    SELECT id
    FROM umbracoNode
    WHERE [path] like '%-20,%'
        AND id !=- 20
        -- Content recycle bin only
        AND nodeObjectType = 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972'

delete from umbracoDomain where id in (select NodeId from @Nodes);
delete from cmsContentNu where nodeId in (select NodeId from @Nodes)
delete from umbracoRedirectUrl where contentKey in (select uniqueId from umbracoNode where id in (select NodeId from @Nodes))
delete from cmsTagRelationship where nodeId in (select NodeId from @Nodes)
delete from umbracoContentSchedule where nodeId in (select NodeId from @Nodes)
delete from umbracoDocumentCultureVariation where nodeId in (select NodeId from @Nodes)
delete from umbracoRelation where parentId in (select NodeId from @Nodes) or childId in (select NodeId from @Nodes)
delete from umbracoUserGroup2NodePermission where nodeId in (select NodeId from @Nodes)
delete from umbracoUserStartNode where startNode in (select NodeId from @Nodes)
update umbracoUserGroup set startContentId = null where startContentId in (select NodeId from @Nodes)
delete from umbracoPropertyData where versionId in (select id from umbracoContentVersion where nodeId in (select NodeId from @Nodes))
delete from umbracoDocumentVersion where id in (select id from umbracoContentVersion where nodeId in (select NodeId from @Nodes))
delete from umbracoContentVersion where nodeId in (select NodeId from @Nodes)
delete from umbracoDocument where nodeId in (select NodeId from @Nodes)
delete from umbracoContent where nodeId in (select NodeId from @Nodes)
delete from umbracoNode where id in (select NodeId from @Nodes)
delete from umbracoUser2NodeNotify where nodeId in (select NodeId from @Nodes)

-- Any custom tables that you have that might need to be cleaned up too.

DELETE FROM @Nodes

--ALTER TABLE umbracoNode CHECK CONSTRAINT FK_umbracoNode_umbracoNode_id

ROLLBACK TRAN

Running this in a transaction allows you to see what is about to happen w/o actually deleting anything. Once you are satisfied with it just change that last line (ROLLBACK TRAN) to COMMIT TRAN

I've also toyed with deleting only items that have been in the recycle bin > 1 month and doing this with a scheduled task. That would change your selection of the nodes to something like:

SELECT id
FROM umbracoNode u
    join umbracoLog l on l.NodeId = u.id
WHERE u.[path] like '%-20,%'
    AND u.id !=- 20
    AND u.nodeObjectType = 'C66BA18E-EAF3-4CFF-8A22-41B16D66A972'
    AND l.logHeader = 'Delete'
    AND l.Datestamp < DateAdd(month, -1, GetDate())

If you do have constraint errors I've used a cursor to iterate over each of the nodes and run the delete statements on them individually. That helps find any nodes that are causing issues. I can probably provide that too if you need it.