DigicomDental
asked on
Help! Need backup script assistance to end process and pause
Hello Experts,
I have a batch file backup script that exports the db file from a live live running Sybase database shortly before ShadowProtect images the drive, since Sybase is not VSS complatible. Here is my script:
CD\
D:
CD Eaglesoft\Shared Files
DBBACKUP -d -t -c "eng=eaglesoft;uid=dba;pwd =sql" "D:\Online_Backup"
The trouble I am having is that sometimes "dbbackup" does not finish the export and hangs somewhere in the process. I need a script that will kill dbackup.exe if it does not complete in 5 minutes and restart the process. It would also be great if there was a way for script to put a "failed" entry in the windows event log when it fails.
Thanks very much!
John
I have a batch file backup script that exports the db file from a live live running Sybase database shortly before ShadowProtect images the drive, since Sybase is not VSS complatible. Here is my script:
CD\
D:
CD Eaglesoft\Shared Files
DBBACKUP -d -t -c "eng=eaglesoft;uid=dba;pwd
The trouble I am having is that sometimes "dbbackup" does not finish the export and hangs somewhere in the process. I need a script that will kill dbackup.exe if it does not complete in 5 minutes and restart the process. It would also be great if there was a way for script to put a "failed" entry in the windows event log when it fails.
Thanks very much!
John
ASKER
Hi Arnold,
Thanks for your reply. ShadowProtect starts the script runs as a "pre-snapshot" task before it does the backup. You can set the amount of time ShadowProtect will wait before the script finishes but the problem is...there is not a way in ShadowProtect to restart the script if is fails.
Thanks for your reply. ShadowProtect starts the script runs as a "pre-snapshot" task before it does the backup. You can set the amount of time ShadowProtect will wait before the script finishes but the problem is...there is not a way in ShadowProtect to restart the script if is fails.
Does shadowprotect continues if the task is not done?
Not sure whether it is possible to have a vbscript as a task. The vbscript will try to backup the database and restart the process until it is done. Does the backup attempt succeed on the second try?
Not sure whether it is possible to have a vbscript as a task. The vbscript will try to backup the database and restart the process until it is done. Does the backup attempt succeed on the second try?
ASKER
Hi Arnold,
Thanks again for your reply. You can set ShadowProtect to continue in the amont of time you specify if the vb script does not complete. The script usually does complete on the second try but dbbackup hangs in windows processes. That is why I need a way to kill dbbackup exe if it does not complete in 5 minutes.
Thanks again for your reply. You can set ShadowProtect to continue in the amont of time you specify if the vb script does not complete. The script usually does complete on the second try but dbbackup hangs in windows processes. That is why I need a way to kill dbbackup exe if it does not complete in 5 minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again, Arnold...I will check those out.
-John
-John
As a scheduled task, you could set the duration for which this process can hang around.