danielrolfe

declare @CleanupList table(ArchivalId uniqueidentifier)
declare @ArchivalId uniqueidentifier
insert into @CleanupList(ArchivalId) 
	select ArchivalId
	from dbo.Archive
	where ArchiveName = 'recyclebin'
while(1 = 1)
begin
    set @ArchivalId = NULL
    select top (1) @ArchivalId = ArchivalId

danielrolfe

$mediasourceRootPath = "master:/sitecore/media library"
$isDryRun = $false

Write-Host "Cleaning up Media Library language versions for all items under this path: " $location

$time = Measure-Command {
    New-UsingBlock (New-Object Sitecore.Data.BulkUpdateContext) {
        New-UsingBlock (New-Object Sitecore.SecurityModel.SecurityDisabler) {
            New-UsingBlock (New-Object Sitecore.Data.DatabaseCacheDisabler) {
                New-UsingBlock (New-Object Sitecore.Data.Events.EventDisabler) {