Veritas NetBackup™ for Sybase Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (8.0)
  1. Introduction to NetBackup for Sybase
    1.  
      About NetBackup for Sybase
    2.  
      Features of NetBackup for Sybase
    3.  
      NetBackup for Sybase terminology
    4. NetBackup for Sybase overview
      1.  
        SQL server and Sybase backup server
      2.  
        NetBackup for Sybase technical overview
      3.  
        Sequence of operation for NetBackup for Sybase backups
    5.  
      NetBackup documentation
  2. Installing NetBackup for Sybase
    1.  
      Planning the installation of NetBackup for Sybase
    2.  
      Verifying the operating system and platform compatibilityVerifying the operating system and platform compatibility for NetBackup for Sybase
    3.  
      NetBackup server and client requirements for NetBackup for Sybase
    4.  
      Sybase server software requirements for NetBackup for Sybase
    5.  
      Requirements for using NetBackup for Sybase in a NetBackup cluster
    6.  
      About the license for NetBackup for Sybase
    7.  
      Copying the NetBackup for Sybase library to each Sybase instance
    8.  
      Running the sybase_config script
    9.  
      Adding new Sybase instances
  3. Configuring NetBackup for Sybase
    1.  
      About NetBackup for Sybase configuration
    2. About configuring a backup policy for a Sybase database
      1.  
        Adding a new NetBackup for Sybase policy
      2.  
        About policy attributes for NetBackup for Sybase
      3. About adding schedules to a NetBackup for Sybase policy
        1.  
          Configuring an application backup schedule (NetBackup for Sybase)
        2.  
          Example application backup schedule (NetBackup for Sybase)
        3.  
          Configuring automatic backup schedules (NetBackup for Sybase)
        4.  
          Example automatic backup schedule (NetBackup for Sybase)
      4.  
        NetBackup for Sybase backup types
      5.  
        About schedule properties (NetBackup for Sybase)
      6.  
        Adding clients to a policy (NetBackup for Sybase)
      7. About backup selections for a Sybase client
        1.  
          About NetBackup for Sybase scripts rules
        2.  
          Adding NetBackup for Sybase scripts to the backup selections list
    3. About the backup, restore, and load scripts for NetBackup for Sybase on UNIX
      1.  
        Modifying the backup script for NetBackup for Sybase on UNIX
      2.  
        Example sybase_mydb_backup.cmd script for NetBackup
      3.  
        Modifying the restore script for NetBackup for Sybase on UNIX
      4.  
        Example of a sybase_mydb_restore script
    4. About the backup, restore, and load scripts for NetBackup for Sybase on Windows
      1.  
        Modifying the backup script for NetBackup for Sybase on Windows
      2.  
        sybase_mdb_backup.cmd script
      3.  
        Additional information for editing the backup script for NetBackup for Sybase on Windows
      4.  
        Modifying the restore script for NetBackup for Sybase on Windows
      5.  
        sybase_mydb_restore.cmd script example for NetBackup
      6.  
        Additional information for editing the restore script for NetBackup for Sybase on Windows
    5.  
      Modifying the NetBackup for Sybase load script
    6.  
      NetBackup for Sybase environment variables
    7. NetBackup for Sybase configuration or bp.conf file settings
      1.  
        Creating a $SYBASE_HOME/bp.conf file on the UNIX client
      2.  
        Specifying options in /usr/openv/netbackup/bp.conf on the UNIX client
    8.  
      Configuring the logon account for the NetBackup Client Service for NetBackup for Sybase
    9. About striped dumps and loads with NetBackup for Sybase
      1.  
        Example Sybase scripts for striped dumps and loads
      2.  
        NetBackup for Sybase multiplexing considerations - duplicating tapes
      3.  
        NetBackup for Sybase multiplexing considerations - using more than 12 stripes
    10.  
      About permissions for NetBackup for Sybase log files (UNIX)
    11.  
      Configuring the Maximum jobs per client (NetBackup for Sybase)
    12.  
      Performing a manual backup (NetBackup for Sybase)
  4. Using NetBackup for Sybase
    1.  
      About using NetBackup for Sybase
    2. About Sybase database backups
      1.  
        Sybase backup strategy
      2.  
        Automatic backups of a Sybase database
      3.  
        Backing up a Sybase database manually
      4.  
        Performing a user-directed backup for Sybase
    3.  
      Browsing Sybase backups
    4. About restoring a Sybase database
      1.  
        Using isql to restore a Sybase database
      2.  
        Configuring a redirected restore on the NetBackup for Sybase client
  5. Troubleshooting NetBackup for Sybase
    1. NetBackup debug logs and reports
      1.  
        Enabling the debug logs for a NetBackup for Sybase client automatically (Windows)
      2.  
        Enabling the debug logs manually (Windows) (NetBackup for Sybase)
      3.  
        Enabling the debug logs manually (UNIX) (NetBackup for Sybase)
      4.  
        About the bphdb directory on the Windows database client
      5.  
        About the bphdb directory on the UNIX database client
      6.  
        About the sybackup directory on the UNIX database client (NetBackup for Sybase)
      7.  
        About the sybackup directory on the Windows database client
      8.  
        Setting the debug level on a Windows client (NetBackup for Sybase)
      9.  
        Setting the debug level on a UNIX client (NetBackup for Sybase)
      10.  
        About NetBackup server reports
    2.  
      Sybase Backup Server log and messages
    3.  
      Minimizing timeout failures on large database restores
    4.  
      Minimizing the loading and unloading of tapes for database backups
    5.  
      Delays in completion of backup jobs

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.

More Information

About configuring a backup policy for a Sybase database

NetBackup for Sybase configuration or bp.conf file settings