rem
rem   to backup the mlc database in success case
rem          parameters
rem                                                         report file
rem
rem 

%sybDir%\win32\dbbackup -y -c "uid=bckdmn;pwd=bckdmn;eng=%1;dbn=%2;Links=tcp" -o %bckDir%/emergency.rpt  %bckDir%/emergency

if errorlevel  255  goto m255
if errorlevel  254  goto m254
if errorlevel  11   goto m11
if errorlevel  10   goto m10
if errorlevel  9    goto m9
if errorlevel  8    goto m8
if errorlevel  7    goto m7
if errorlevel  6    goto m6
if errorlevel  5    goto m5
if errorlevel  4    goto m4
if errorlevel  3    goto m3
if errorlevel  2    goto m2
if errorlevel  1    goto m1
echo  SUCCESS                             >>%bckDir%\message.
.

goto m_good
:m255
echo  Invalid parameters on command line  >>%bckDir%\message.
goto message
:m254
echo  Reached stop time                   >>%bckDir%\message.
goto message
:m11
echo  Database server not found           >>%bckDir%\message.
goto message
:m10
echo  Database engine not running         >>%bckDir%\message.
goto message
:m9
echo Unable to connect to database engine >>%bckDir%\message.
goto message
:m8
echo Client/server protocol mismatch      >>%bckDir%\message.
goto message
:m7
echo Missing required database name       >>%bckDir%\message.
goto message
:m6
echo Failed communications                >>%bckDir%\message.
goto message
:m5
echo Terminated by user                   >>%bckDir%\message.
goto message
:m4
echo Out of memory                        >>%bckDir%\message.
goto message
:m3
echo File not found, unable to open, and so on    >>%bckDir%\message.
goto message
:m2
echo Invalid file format, and so on       >>%bckDir%\message.
goto message
:m1
echo General failure                      >>%bckDir%\message.
goto message


:m_good

:message

rem
rem        xmail - it is tools to send e-mail.
rem        SMTP-server
rem                       FROM
rem                                  TO 
rem                                         SUBJECT
rem
rem                                                       body of
rem                                                       message
rem
rem   do a success message?
rem
rem pause
rem echo on

%utDir%\xmail  -h %smtpSrv% -f %bckDmnEMl% -t %bckDmnEMl% -s "MMB %lclNm% ERROR ver %4 database %1(%2)" <% 3 \message. >>% 3 \history.log

rem
rem    send message alert by LAN
rem      LAN users of MMB
rem
net send %usrAlert% "MMB %lclNm% ERROR ver %4 database %1(%2)" >>% 3 \history.log

rem
rem this file includes all the variables should to be used for 
rem        installation, backup and maitenance MMB server
rem

rem
rem  parameters of sybase
rem

set sybVer= 9 
set sybDir=c:\bin\syb

rem
rem  identification of backup server   (local)
rem

set lclNm=Bavarian
set lclEng=test_db
set lclDb=test_db

xcopy бла бла бла

if errorlevel  255  goto m255
if errorlevel  2    goto m2
if errorlevel  1    goto m1
echo  SUCCESS                             >>%bckDir%\message.
.

goto m_good

:m255
echo  Invalid parameters on command line  >>%bckDir%\message.
goto message

:m2
echo Invalid file format, and so on       >>%bckDir%\message.
goto message

:m1
echo General failure                      >>%bckDir%\message.
goto message


:m_good