Backup Firebird - Copia e Compactacao

gistfile1.txt

FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H)
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H)
set zip="C:\Program Files (x86)\7-Zip\7z.exe"
set mysqldump="C:\Program Files (x86)\Firebird\Firebird_2_5\bin\gbak.exe"
set homedir=C:\BACKUPS\Sigma_Backup\GBK\
set fname=%v_date%_%v_time%
echo %vdate% %v_time% - %fname%

cd %homedir%

md %date:~0,2%%date:~3,2%%date:~6,4%

xcopy C:\Sigma_Banco\NOVO_SIGMAPDCA_IGUACU_PRD.FDB C:\BACKUPS\Sigma_Backup\GBK\%date:~0,2%%date:~3,2%%date:~6,4%\

%zip% a C:\BACKUPS\Sigma_Backup\GBK\sigma_%fname%.7z C:\BACKUPS\Sigma_Backup\GBK\%date:~0,2%%date:~3,2%%date:~6,4%\NOVO_SIGMAPDCA_IGUACU_PRD.FDB

rmdir /S /Q %date:~0,2%%date:~3,2%%date:~6,4%