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.