Re: Shutdown from OS Batch File (NT40), and Backup

svpett_at_online.no (Svein-Egil Pettersen) writes:

>Does anyone know how to make an OS Batchjob to shutdown
>the DB before backup, and then start the DB after
>Backup. I am using Cheyenne Arcserve backup SW. Cheyenne
>has the possibility to do 'Before backup job' and
>'After Backup job' in the backup task.
>This shutdown and startup has to go without any
>user action. This is a fullvolum backup job of all
>partitions and all disks.
>Perhaps even an export before backup starts.

Write a batch script using svrmgrl (server manager line mode). For example,

svrmgr23 @do-backup.sql

Where do-backup.sql contains:

connect internal_at_2:DBSID
shutdown immediate
startup restrict
shutdown
exit

--

Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.