@echo off
echo 正在备份数据库文件,请稍等......
exp.exe report/ok@report file=d:/reportBack/report%date%.dmp log=d:/reportBack/report%date:~0,10%.log
echo 正在删除备份文件,请稍等......
rem 需要Win2003/Vista/Win7系统自带的forfiles命令的支持
rem forfiles /p "d:/reportBack" /d -2 /c "cmd /c del /f @path"
rem 指定待删除文件的存放路径
set SrcDir=d:/reportBack
rem 指定天数
set DaysAgo=2
for /f "skip=2 delims=" %%a in ('reg query "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate') do (
set "RegDateOld=%%a"
)
set RegDateOld=%RegDateOld:~-8%
reg add "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate /t REG_SZ /d yyyy-M-d /f>nul
>"%temp%/DstDate.vbs" echo LastDate=date()-%DaysAgo%
>>"%temp%/DstDate.vbs" echo FmtDate=right(year(LastDate),4) ^& right("0" ^& month(LastDate),2) ^& right("0" ^& day(LastDate),2)
>>"%temp%/DstDate.vbs" echo wscript.echo FmtDate
for /f %%a in ('cscript /nologo "%temp%/DstDate.vbs"') do (
set "DstDate=%%a"
)
set DstDate=%DstDate:~0,4%-%DstDate:~4,2%-%DstDate:~6,2%
for /r "%SrcDir%" %%a in (*.*) do (
if "%%~ta" leq "%DstDate%" (
if exist "%%a" (
del /f /q "%%a"
)
)
)
reg add "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate /t REG_SZ /d %RegDateOld% /f>nul
@echo 删除成功!
@echo 备份成功!