Popis zálohování

backup.bat
for /f "tokens=2 delims==" %%I in ('wmic os get localdatetime /format:list') do set datetime=%%I
set datetime=%datetime:~0,8%-%datetime:~8,6%
::echo %datetime%
for /f %%a in ('wmic path win32_localtime get dayofweek /format:list ^| findstr "="') do (set %%a)
::echo %DayOfWeek%
 
 
:: Del Old Files
forfiles /p C:\Data\Zalohy\BW_server\nocni_zaloha /m bw_*.7z /d -3 /c "cmd /c del @FILE"
:: Backup All BW_* databases
sqlcmd -S srv01\sqlexpress -i C:\Data\Scripts\SQLBackup.sql
:: Compress all files to one
C:\Data\utils\7z.exe a C:\Data\Zalohy\BW_server\nocni_zaloha\BW_%datetime%.7z C:\Data\Zalohy\BW_server\nocni_zaloha\*.bak
:: Delete *.bak files
del \data\Zalohy\BW_server\nocni_zaloha\*.bak
:: Copy to remote backup store
::copy C:\Data\Zalohy\BW_server\nocni_zaloha\BW_20160920-225236.7z \\192.168.0.254\data\db\db_backup_%DayOfWeek%.7z /Y
copy C:\Data\Zalohy\BW_server\nocni_zaloha\BW_%datetime%.7z \\192.168.0.254\data\db\db_backup_%DayOfWeek%.7z /Y
:: Taxedit backup to remote store
C:\Data\Utils\Process.exe -k FastCopy.exe
C:\Data\Utils\FastCopy\fastcopy.exe /force_close /error_stop=FALSE /log /logfile="c:\data\logs\sync_taxedit.log" C:\Data\taxedit /to="\\192.168.0.254\data\taxedit"
DokuWiki Appliance - Powered by TurnKey Linux