Remove old SQL Server Transaction log, and Backup log, dump files.

remove-sqllogs.ps1

#remove sql server old files
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") 
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended") 
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum") 

#create a new server object
$server = New-Object ("Microsoft.SqlServer.Management.Smo.Server") "(local)"
$backupDirectory = $server.BackupDirectory
$folders = get-childitem $backupDirectory -Directory 

foreach($folder in $folders){
  $fullpath = Join-Path $backupDirectory -ChildPath $folder
  if((Get-ChildItem $fullpath -Filter *.trn ).Exists -eq $true){
    $newesttime = (Get-ChildItem $fullpath  -Filter *.bak | Sort-Object lastwritetime -Descending)[0].LastWriteTime
    Get-ChildItem $fullpath -Filter *.trn | ForEach-Object { if($_.LastWriteTime -lt $newesttime){ remove-item $_.FullName }}
  }
}

$logDirectory = $server.ErrorLogPath
$extensions = "*.txt","*.log","*.mdmp"
foreach($ext in $extensions){
  Get-ChildItem $logDirectory -Recurse -Filter $ext | ForEach-Object { if($_.lastwritetime.adddays(3) -lt [Datetime]::Now) {remove-item $_.fullname }}
}