Hi,

I'm using the following cmd file to backup my live databases twice a day
via a Windows Scheduled Event. Is it okay with the experts or am I
leaving myself open for disaster?

===========================================
C:\Firebird\bin\gbak.exe -t -g -co -user SYSDBA -password ******** -y
c:\utils\backup2.txt 192.168.2.2:"C:\Documents And Settings\All
Users\Documents\VOCALPOINT.FDB" D:\VOCALPOINT.FBK
C:\Firebird\bin\gbak.exe -t -g -co -user SYSDBA -password ******** -y
c:\utils\backup3.txt 192.168.2.100:"C:\Documents And Settings\All
Users\Documents\VOCALPOINT.FDB" D:\VOCALPOINT_REMOTE.FBK
if errorlevel 1 goto problem
if errorlevel 0 goto exit
:exit
C:\usr\sbin\sendmail -messagefile=c:\utils\backup2.txt
-subject="Completed Firebird Backup Notification" *******@**************
del c:\utils\backup2.txt
del c:\utils\backup3.txt
j:
xcopy "d:\*.fbk" /y
exit
:problem
C:\usr\sbin\sendmail -messagefile=c:\utils\backup2.txt -subject="Failed
Firebird Backup Notification" *******@**************
del c:\utils\backup2.txt
del c:\utils\backup3.txt
exit
===========================================

Thanks,

Rob Davis