@echo off
REM ------------------------------------------------------------------------------
REM Created by Shine Li at 2017-10-30
REM 功能:定期删除数据库备份文件
REM 设置DayAgo参数来保留最近多少天的备份
REM ------------------------------------------------------------------------------
REM ------------------------------------------------------------------------------
REM 如果显示的待删除文件列表正确无误
REM 把 Select-Object FullName 修改成 Remove-Item -Force 再次执行即可真正删除文件
REM Win7/Win8/Win10等系统自带PowerShell
REM ------------------------------------------------------------------------------
set Dir=G:\schedule_jobs
REM 指定待删除文件的存放路径
set SrcDir=G:\app\Administrator\admin\dz\dpdump
REM 指定天数
set DaysAgo=30
echo =================================begin to delete backup===============================>>%Dir%\del_backup.log
powershell -c "Get-ChildItem -Path '%SrcDir%' -Recurse -ErrorAction:SilentlyContinue | Where-Object -FilterScript {(((get-date) - ($_.LastWriteTime)).days -gt %DaysAgo% -and $_.PsISContainer -ne $True)} | Select-Object FullName">>%Dir%\del_backup.log
powershell -c "Get-ChildItem -Path '%SrcDir%' -Recurse -ErrorAction:SilentlyContinue | Where-Object -FilterScript {(((get-date) - ($_.LastWriteTime)).days -gt %DaysAgo% -and $_.PsISContainer -ne $True)} | Remove-Item -Force"
echo =====================================delete completed......===========================>>%Dir%\del_backup.log
rem pause
REM ------------------------------------------------------------------------------
REM Created by Shine Li at 2017-10-30
REM 功能:定期删除数据库备份文件
REM 设置DayAgo参数来保留最近多少天的备份
REM ------------------------------------------------------------------------------
REM ------------------------------------------------------------------------------
REM 如果显示的待删除文件列表正确无误
REM 把 Select-Object FullName 修改成 Remove-Item -Force 再次执行即可真正删除文件
REM Win7/Win8/Win10等系统自带PowerShell
REM ------------------------------------------------------------------------------
set Dir=G:\schedule_jobs
REM 指定待删除文件的存放路径
set SrcDir=G:\app\Administrator\admin\dz\dpdump
REM 指定天数
set DaysAgo=30
echo =================================begin to delete backup===============================>>%Dir%\del_backup.log
powershell -c "Get-ChildItem -Path '%SrcDir%' -Recurse -ErrorAction:SilentlyContinue | Where-Object -FilterScript {(((get-date) - ($_.LastWriteTime)).days -gt %DaysAgo% -and $_.PsISContainer -ne $True)} | Select-Object FullName">>%Dir%\del_backup.log
powershell -c "Get-ChildItem -Path '%SrcDir%' -Recurse -ErrorAction:SilentlyContinue | Where-Object -FilterScript {(((get-date) - ($_.LastWriteTime)).days -gt %DaysAgo% -and $_.PsISContainer -ne $True)} | Remove-Item -Force"
echo =====================================delete completed......===========================>>%Dir%\del_backup.log
rem pause