How does delete older files - PowerShell

Content
Because of backing SQL Database up daily, we need to delete older backup files for free space. We make use PowerShell (PS) help us automatically.

$limit = (Get-Date).AddDays(-30)

$sqlBackupPath = 'C:\SQLBackup'

{Get-ChildItem | gci} $sqlBackupPath | ? {
-not $_.PSIsContainer -and $_.LastWriteTime -lt $limit -and $_.Name -like '*.sql'
} | Remove-Item

To delete files in subfolders, you should modify it to be

gci $sqlBackupPath -Recurse

To run the PS file daily, we firstly set PS execution policy.

PS C:\Set-ExecutionPolicy RemoteSigned

Then, configured a scheduled task to be

C:\WINDOWS\system32\WindowsPowerShell\v1.0\powershell.exe & 'C:\bin\del older SQL backup.ps1'

Reference

• PS to delete files older than X days

Update