###FUNCTION TO DELETE OLD FILES
function deleteOldFiles
(
[int]$numberOfDays = $(throw "Specify the number of days")
)
{
$Now = Get-Date
$TargetFolder = “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup”
$LastWrite = $Now.AddDays(-$numberOfDays)
$Files = get-childitem $TargetFolder -include *.bak, *.x86 -recurse | Where {$_.LastWriteTime -le “$LastWrite”}
foreach ($File in $Files)
{
write-host “Deleting File $File” -foregroundcolor “Red”;
Remove-Item $File | out-null
}
}
deleteOldFiles(3)
Thanks a lot!
thanks alot