Additional information for editing the backup script for NetBackup for Sybase on Windows
@set SYBASE=C:\Sybase
Set this variable to the Sybase home folder. Typically set to the same value as the SYBASE environment variable.
@set SYBSERVER=SYBASE
Set this variable to the name of the Sybase adaptive server. Typically set to the same value as the DSQUERY environment variable.
@set DATABASE_NAME=SYB_DB
Set this variable to the name of your Sybase database.
if "%SYBACKUP_SCHED%" == "database_dump" goto dbdump
Replace database_dump with the Automatic Backup schedule name that is used to schedule database dumps. You already configured this Automatic Backup schedule.
@echo dump %DUMP_TYPE% %DATABASE_NAME% to "sybackup::-SERV %SYBACKUP_SERVER% -POLICY %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" > .\syb_%DATABASE_NAME%_dump
This line builds the dump command that isql processes. Change the NetBackup server name (%SYBACKUP_SERVER%), the Sybase policy name (%SYBACKUP_POLICY%), and Application Backup schedule name (Default-Application-Backup) to fit your environment. Do not change the name of the client status file (%STATUS_FILE%).
@REM echo stripe on "sybackup::-SERV %SYBACKUP_SERVER% -POLICY %SYBACKUP_POLICY% -SCHED Default-Application-Backup -STAT_FILE %STATUS_FILE%" >> .\syb_%DATABASE_NAME%_dump
Change the NetBackup server name (%SYBACKUP_SERVER%), the Sybase policy name (%SYBACKUP_POLICY%), and Application Backup schedule name (%SYBACKUP_POLICY%) to match the @echo dump line described previously in this table. Repeat this line for each additional stripe that you plan to use to backup the database.
If you are going to use multiple stripes to back up the Sybase database, delete REM from this line.
set CMD_LINE=%SYBASE%%OCS_QUAL%\bin\isql -Usa -Pmanager -I%SYBASE%\ini\sql.ini -S%SYBSERVER%
Replace manager with the adaptive server password for the administrator.