After reading the documentation for the SQL Agent it seems a fairly
complicated routine is required to fully backup the SQL and NT server
properly, allowing DB file restore and also allowing for  a full server
restore. Is this the case ? Is there a simpler way of backing up SQL than
the one outlined below ?


I think I need to use a routine similar to the following:

1. Periodically backup the entire NT Server (once a week), including the SQL
devices by running Scheduled ADSM server backup that executes a script on
the target node stopping the SQL service, which enables the SQL devices to
be copied. Another script needs to be executed after the backup has finished
to start the SQL services.

2. A daily backup of the server that also runs a script, this time executing
the Connect Agent for SQL command line to back-up up the SQL databases after
an incremental server backup. The server backup in this case will NOT
back-up the SQL device as the SQL service is still running denying ADSM
access to the device.


The difficulty I am having with this routine is to specify the different
scripts to execute. The .OPT file allows a pre & post script to be run but I
need to run  a 3rd script for my periodic full backup when I need to stop
the SQL service.
How do I specify a script using the Administrative Client GUI (NT)?

Help !

Jason Warwick