commande forfiles pour nettoyer des sauvegardes SQL .. ici on conserve seulement 15j de sauvegarde :
With FORFILES.EXE (downloadable version):
c:\FORFILES.exe -p"D:\SAUVEGARDESQL" -s -m*.bak -d-15 -c"CMD /C del @FILE"
c:\FORFILES.exe -p"D:\SAUVEGARDESQL" -s -m*.txt -d-15 -c"CMD /C del @FILE"
c:\FORFILES.exe -p"D:\SAUVEGARDESQL" -s -m*.trn -d-15 -c"CMD /C del @FILE"
With FORFILES.EXE included in WINDOWS 2008:
FORFILES.exe /p "S:\SQL-BACKUP" /s /m *.bak /d -30 -c "CMD /C del @FILE"
FORFILES.exe /p "S:\SQL-BACKUP" /s /m *.txt /d -30 -c "CMD /C del @FILE"
FORFILES.exe /p "S:\SQL-BACKUP" /s /m *.trn /d -30 -c "CMD /C del @FILE"
With FORFILES.EXE (downloadable version):
FORFILES et 7ZIP.EXE (compress backup sql files / BAK using forfiles.exe):
c:\FORFILES.exe -p"C:\BACKUP_SQL" -m*.bak -s -c"CMD /C C:\Progra~1\7-Zip\7z.exe a @FILE.7z @FILE"
older than 3 days ...
c:\FORFILES.exe -p"C:\BACKUP_SQL" -m*.bak -s -d-3 /c"CMD /C C:\Progra~1\7-Zip\7z.exe a @FILE.7z @FILE"
then delete oldest ...
c:\FORFILES.exe -p"C:\BACKUP_SQL" -m*.7z -d-30 -s -c"CMD /C del @FILE"
Delete folders and subfolders:
ForFiles /P D:\MYFOLDER /D -35 /C “CMD /C if @ISDIR==TRUE echo RD /Q @FILE &RD /Q /S @FILE”
FORFILES /?
FORFILES
FORFILES /P C:\WINDOWS /S /M DNS*.*
FORFILES /S /M *.txt /C "cmd /c type @file | more"
FORFILES /P C:\ /S /M *.bat
FORFILES /D -30 /M *.exe
/C "cmd /c echo @path 0x09 a été modifié il y a 30 jours"
FORFILES /D 01/01/2001
/C "cmd /c echo @fname est nouveau depuis le 1er jan. 2001"
FORFILES /D +25/1/2018 /C "cmd /c echo @fname date de ce jour"
FORFILES /M *.exe /D +1
FORFILES /S /M *.doc /C "cmd /c echo @fsize"
FORFILES /M *.txt /C "cmd /c if @isdir==FALSE notepad.exe @file"
Edited 5 time(s). Last edit at 01/25/2018 04:00PM by iznogoud.