Automated Shut Down/Restart of DB

[Guest]

I have a client management system that has Sybase ASA database engine running
under Windows 2000 Server. The backup program (Veritas Back-up Exec) that we
use on our server will not back up Sybase while it is still running. We have
to manually shut down the database from the console before taking a backup
each night and then restart it every morning manually.
I would like to automate this task. Is there a way I can execute the shut
down program through a batch file using the Windows Task scheduler before the
Back-up job runs (11:00pm) and then execute the start-up program after the
back-up job runs say at 6:00am? If this possible how would I do this? or
perhaps there is a better way to this? The vendors offer no help...
Thanks

 

[Pegasus \(MVP\)]

I have a client management system that has Sybase ASA database engine running
under Windows 2000 Server. The backup program (Veritas Back-up Exec) that we
use on our server will not back up Sybase while it is still running. We have
to manually shut down the database from the console before taking a backup
each night and then restart it every morning manually.
I would like to automate this task. Is there a way I can execute the shut
down program through a batch file using the Windows Task scheduler before the
Back-up job runs (11:00pm) and then execute the start-up program after the
back-up job runs say at 6:00am? If this possible how would I do this? or
perhaps there is a better way to this? The vendors offer no help...
Thanks

You could use kill.exe to shut down the program, then relaunch it
in the same way as you normally launch it. Both actions can be
triggered with the Task Scheduler.

Kill.exe comes with the Win2000 Resource Kit. I believe a free
version (pskill.exe?) is available from www.sysinternals.com.