Re: Automated backup for Online & NT?

The following info is from the NT Help file: The Windows NT Backup utility, Ntbackup, does not include functionality for scheduling unattended backups. However, by using the Schedule service with the command line capabilities of the Ntbackup utility, you can set up unattended backups. The following procedure shows how to use the Schedule service and the Ntbackup utility to schedule an unattended backup of the entire C drive of a computer with an installed tape device. With minor modifications, these steps could also allow for scheduling unattended backups from a computer on a network to a computer with an installed tape device or other configurations. To schedule unattended backup 1. Start the Schedule service on the computer with the tape device already installed. This can be done by using the Services option in Control Panel, clicking Schedule, and clicking Start. Alternatively, you can configure the Schedule service to start every time Windows NT starts by clicking Startup and setting the Startup Type to Automatic. 2. Using any text editor, such as Notepad, create a command file, such as, Mybackup.cmd to perform the commands to backup the files. This example ntbackup backup c: /D "My Backup Files" /B /L "c:\\backup.log" does the following: ' Backs up all files on the C drive. ' Replaces any files currently on the tape. ' Labels the backup set "My Backup Files." ' Backs up the local registry. ' Logs all backup information to C:\\Backup.log. 3. Using the AT command, schedule the command file (Mybackup.cmd) to run when desired. The following AT command schedules Mybackup.cmd to execute at 11:00 P.M. every Monday, Wednesday, and Friday: AT 23:00 /every:M,W,F MYBACKUP.CMD When there is no tape in the drive and you use the AT command without the interactive switch to run Windows NT Backup, the backup encounters an error or is unable to accept the command line. As a result, Windows NT Backup stops responding. You cannot run Windows NT Backup again until you restart Windows NT. Use the /INTERACTIVE switch with the AT command to open the interactive desktop. This way, if any errors occur, you will be able to correct them and continue, or quit Windows NT Backup. For information about AT options, type AT /? at a command prompt or search the online Command Reference for AT. For additional information on available Ntbackup options, use the Help menu when running Ntbackup.exe. So, from there, you can figure out how to run the Informix backup from the same type of CMD file, I hope :) Martie spasco@unibiz.com wrote: > > Hi, everyone. I was hoping someone might be able to help me out on this one... > I work for a software house that creates and implements data warehousing > systems. It is a Windows NT 4.x application, that we develop, and all systems > use Informix Online DS 7.3 (others that are not are in the process of being > upgraded). The database is generally hosted by an NT machine as well. All of > the smaller operations have no on-staff DBAs and generally run automated backups > at a pre-determined hour. Does anyone know of a way to run an automated backup > (tape or other) that would produce the same effects as an 'onstat -s' command? > Or, at the very least, a utility that would help the low-maintenance types out? > Further, being small locations, they don't want to pay a lot of money for one. > I appreciate everyone's time. > > Shawn Pasco > Unique Business Systems > Project Manager > 310.396.3929 ext. 109 / spasco@unibiz.com