下面share一个windows上的脚本,主要目的是把数据库的备份迁移到其他存储设备上
C:
cd C:\Backup
net use z: \\dbbackup
set dd=%date:~6,4%_%date:~0,2%_%date:~3,2%
dir *%dd%*.bak /s/b/a>baklist.txt
for /f %%i in (baklist.txt) do gzip -f "%%i"
dir *%dd%*.bak.gz /s/b/a>rarlist.txt
for /f %%g in (rarlist.txt) do move "%%g" z:\backup\
forfiles /p "z:\backup" /m "*.bak.gz" /s /c "cmd /c del /s @path" /d -30
net use z: /delete /yes
C:
cd C:\Backup
net use z: \\dbbackup
set dd=%date:~6,4%_%date:~0,2%_%date:~3,2%
dir *%dd%*.bak /s/b/a>baklist.txt
for /f %%i in (baklist.txt) do gzip -f "%%i"
dir *%dd%*.bak.gz /s/b/a>rarlist.txt
for /f %%g in (rarlist.txt) do move "%%g" z:\backup\
forfiles /p "z:\backup" /m "*.bak.gz" /s /c "cmd /c del /s @path" /d -30
net use z: /delete /yes
PS:在windows server 2008上的schedule job时,如果net use z: /delete 无法umount卷,导致job运行了没有结果,必须加
/yes,强制关闭卷
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21560888/viewspace-1717073/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21560888/viewspace-1717073/