Veritas NetBackup™ for Sybase Administrator's Guide

Last Published:
Product(s): NetBackup (8.1.1, 8.1)
  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
  2. Installing NetBackup for Sybase
    1.  
      Planning the installation of NetBackup for Sybase
    2.  
      Verifying the operating system and platform compatibility
    3.  
      NetBackup server and client requirements
    4.  
      Sybase server software requirementsSybase 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
      3. About adding schedules to a NetBackup for Sybase policy
        1.  
          Configuring an application backup schedule
        2.  
          Example application backup schedule
        3.  
          Configuring automatic backup schedules
        4.  
          Example automatic backup schedule
      4.  
        NetBackup for Sybase backup types
      5.  
        About schedule properties
      6.  
        Adding clients to a policy
      7.  
        Adding NetBackup for Sybase scripts to the backup selections list
      8.  
        Rules for NetBackup for Sybase scripts
    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.  
      Reviewing the auto-discovered mappings in Host Management
    11.  
      About permissions for NetBackup for Sybase log files (UNIX)
    12.  
      Configuring the Maximum jobs per client
    13.  
      Performing a manual backup
  4. Using NetBackup for Sybase
    1. 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
    2.  
      Browsing Sybase backups
    3. 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)
      3.  
        Enabling the debug logs manually (UNIX)
      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
      7.  
        About the sybackup directory on the Windows database client
      8.  
        Setting the debug level on a Windows client
      9.  
        Setting the debug level on a UNIX client
      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
  6. Appendix A. Register authorized locations
    1.  
      Registering authorized locations used by a NetBackup database script-based policy

Features of NetBackup for Sybase

Table: NetBackup for Sybase features and descriptions shows NetBackup for Sybase's main features and introduces some terms used in this documentation.

Table: NetBackup for Sybase features and descriptions

Feature

Description

Media and device management

All devices supported by Media Manager are available to NetBackup for Sybase.

Scheduling facilities

NetBackup scheduling facilities on the master server can be used to schedule automatic and unattended Sybase backups.

This feature also lets you choose the times when these operations can occur. For example, to prevent interference with normal daytime operations, you can schedule your database backups to occur only at night.

Multiplexed backups and restores

NetBackup for Sybase lets you take advantage of NetBackup's multiplexing capabilities. Multiplexing directs multiple data streams to one backup device, thereby reducing the time necessary to complete the operation.

Transparent Sybase and regular file system backup and restore operations

All backups and restores run simultaneously and transparently without any action from the NetBackup administrator.

The database administrator can run database backup and restore operations through NetBackup. An administrator or any other authorized user can use NetBackup to run database backups and restores.

Sharing the same storage units used for other file backups

It is possible to share the same devices and media used for other backups or to give Sybase exclusive use of certain devices and media. NetBackup for Sybase can use Media Manager, disk, and PureDisk storage units.

Centralized and networked backup operations

From the NetBackup master server, you can schedule database backups or start them manually for any client. The Sybase databases can also reside on hosts that are different from the devices on which NetBackup stores the backups.

Graphical user interfaces

NetBackup provides the following graphical user interfaces for client users and administrators:

  • NetBackup Administration Console

  • Backup, Archive, and Restore user interface

A database administrator or NetBackup administrator can start backup or restore operations for Sybase from the NetBackup graphical user interface on the master server.

Parallel backup and restore operations

NetBackup for Sybase supports the parallel backup and restore capabilities of the Sybase backup server. For example, this permits the user to run more than one tape device at a time for a single Sybase backup or restore, thereby reducing the time necessary to complete the operation.

Compression

Compression increases backup performance over the network and reduces the size of the backup image that NetBackup writes to the storage unit.