Kbase 20326: Stop and Start Scripts for 3rd Party Windows Backup Utilities
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2008 |
|
Status: Verified
GOAL:
Stop and start scripts for 3rd party Windows backup utilities.
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FIX:
Many third party backup products (Cheyenne ArcServe, Computer Associates ARCserveIT, Legato Networker, NT Backup, Arcada Backup, Seagate Software Backup, Veritas Backup) allow pre and post backup execution of batch files to handle tasks like shutting down and restarting a database for off-line backup.
The solution provides a simple example of scripts for third party backups. Please refer to the manual of the backup software to see how the process is implemented for specific backup software.
Examples of backup scripts:
STOPDB.BAT
@echo off
touch c:\temp\stopdb.txt
c:\apps\progress\bin\pccmd databases stop mydatabase1
c:\apps\progress\bin\pccmd databases stop mydb2
STARTDB.BAT
@echo off
touch c:\temp\startdb.txt
c:\apps\progress\bin\pccmd databases start mydatabase1
c:\apps\progress\bin\pccmd databases start mydb2
The "@echo off" line hides any output to the screen. The "touch" command is a UNIX command and not generally found on a Windows machine by default, however freeware versions do exist for Windows, it is used for administrative purposes and changes the date and time of the text file, to show when the batch file was executed. The next two lines actually stop and start the databases with the PCCMD command.
You can use the following windows command instead of "touch"....
type nul > c:\temp\stopdb.txt
It works in all versions of windows and does not require a separate freeware utility.