备份次新的DR(sql server dmp文件)

#----------------------F:\CVDR\scripts\cvdr2169.bat-------------------#
@echo off

set folder=F:\CVDR
set tempfile="%tmp%\fjz.tmp"

del/a/f/q %tempfile%

for /f "usebackq delims=" %%A in (`dir /ad /od /tc /b "%folder%"`) do (
         echo %%A>>%tempfile%
         set newest_folder=%%A
)
for /f "usebackq delims=" %%A in (`type %tempfile%^|find /v "%newest_folder%"`) do set second_newest_folder=%%A
echo second_newest_folder=%second_newest_folder%

del/a/f/q %tempfile%

cd /d %folder%\%second_newest_folder%

forfiles /p %folder%\%second_newest_folder% /m *.dmp /c "cmd /c copy @path d:\cvdr_to_16.9"

cd /d d:\cvdr_to_16.9

C:\Windows\System32\ftp.exe -s:F:\CVDR\script\cvdr2169_ftp.txt


#-----cvdr2169_ftp.txt ---#
open 10.242.16.9
cvdr
cvdr
bin
prom
mput *.dmp
bye

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22661144/viewspace-1430678/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22661144/viewspace-1430678/