Honeywell MAXPRO, Operator'S Manual

Page: 230 / 256

A P P E N D I X A
Metadata and Database Backup
230 MAXPRO NVR 3.1 Operator’s Guide
A
echo %DATESTAMP%
set DBfilename=%DatabaseFolder%\Trinity_%DATESTAMP%.bak
SQLCMD.exe -S %MACHINENAME%\%INSTANCENAME% -E -Q "BACKUP DATABASE
[TrinityDatabase] TO DISK = N'%DBfilename%' WITH NOFORMAT, INIT, NAME = N'Trinity-
Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10" >>
%CURRENT_PATH%Bkp_Log.txt
echo %DatabaseFolder%
forfiles /p %DatabaseFolder% /s /d -7 /c "cmd /c del @file : date >= 7 days >NUL"
echo ********************************************************************* >>
%CURRENT_PATH%Bkp_Log.txt
echo Backup Complete - MAXPRONVR Metadata and Database Backup is created
successfully.
echo Backup Complete - MAXPRONVR Metadata and Database Backup is created
successfully. >> %CURRENT_PATH%Bkp_Log.txt
echo ********************************************************************* >>
%CURRENT_PATH%Bkp_Log.txt
EXIT
:trimSpaces varref -- trims spaces around string variable
:: -- varref [in,out] - variable to be trimmed
call call:trimSpaces2 %~1 %%%~1%%
EXIT /b
:trimSpaces2 retval string -- trims spaces around string and assigns result to variable
:: -- retvar [out] variable name to store the result in
:: -- string [in] string to trim, must not be in quotes
for /f "tokens=1*" %%A in ("%*") do set "%%A=%%B"
EXIT /b
REM *********************************************************************
Note:
To change the Backup Drive, please change the value set BackupDBDrive=D:\.
15. Click Next after you have selected the above batch file. The Summary dialog box
appears.
16. Verify the information, and click Finish .