Symantec NetBackup for Microsoft SQL Server Administrator's Guide

• Symantec NetBackup for Microsoft SQL Server Administrator's Guide
  • Introduction to NetBackup for SQL Server
    • Overview of NetBackup for SQL Server
    • About NetBackup for SQL features
      • NetBackup operations
      • Graphical user interface
    • NetBackup for SQL Server terms
    • Technical overview
      • What are the components of NetBackup for SQL Server?
      • How does NetBackup for SQL Server back up a database?
      • How does NetBackup for SQL Server recover a database?
      • What factors affect the data transfer rate during a SQL Server backup or restore operation?
      • How does NetBackup resolve SQL Server host and instance names?
  • Installing NetBackup for SQL Server
    • About installing the NetBackup for SQL Server agent
    • Verifying the operating system and platform compatibility for NetBackup for SQL Server
    • NetBackup server and client software requirements for NetBackup for SQL Server
    • SQL Server server software requirements for NetBackup for SQL Server
    • Requirements for installing NetBackup for SQL Server in a NetBackup cluster
    • About support for Microsoft Cluster server (MSCS) clusters with NetBackup for SQL
    • About support for Veritas Cluster Server (VCS) clusters with NetBackup for SQL
    • Configuration and licensing requirements for NetBackup for SQL Server with Snapshot Client
    • Adding the NetBackup for SQL Server license key
  • Configuring NetBackup for SQL Server
    • About user interface terminology
    • Configuring the Maximum jobs per client
      • Formula for Maximum jobs per client
    • About configuring a backup policy for an SQL Server database
      • Adding a new NetBackup for SQL Server policy
      • About policy attributes for NetBackup for SQL Server
      • About adding schedules to a NetBackup for SQL Server policy
        • Configuring an Application Backup schedule
        • Example Application Backup schedule for NetBackup for SQL Server
        • Configuring automatic backup schedules
        • Example automatic backup schedule for NetBackup for SQL Server
      • About NetBackup for SQL Server schedule properties
      • About the types of NetBackup for SQL Server backups
      • Adding clients to a NetBackup for SQL Server policy
      • Adding backup selections to a NetBackup for SQL Server policy
      • Adding batch files to the backup selections list
    • Testing configuration settings
    • Configuring multistream operations
      • Configuring multistriped backups
      • Configuring multiplexed backups
    • About configuration for a multi-interface network connection (multi-NIC)
      • Configuring the master server for a multi-NIC
      • Configuring a policy for a multi-NIC
      • Adding the permissions that allow for browsing of backups across the private interface
      • Configuring the client for a multi-NIC
        • Specifying the private name of the client for a multi-NIC
        • Specifying the public name of the client for a multi-NIC
    • About SQL Server privileges
    • About setting the SQL Server logon for scheduled operations
    • Authorizing scheduled operations (for sites with SQL Server security restrictions)
    • Mapping a Windows account to a standard SQL Server user ID
    • Performance factors
      • Buffer space parameters
        • MAXTRANSFERSIZE
        • BLOCKSIZE
        • NUMBER OF BUFFERS PER STRIPE
      • Backup stripes
      • Shared memory usage
      • Alternate buffer method
        • Alternate buffer method with backup operations
        • Alternate buffer method with restore operations
      • Page verification
      • Instant data file initialization
      • Using read-write and read-only filegroups
    • Backing up SQL Server in an environment with log shipping
  • Backup and recovery concepts
    • Overview of backup and recovery concepts
    • Overview
      • SQL Server system database types
      • Database backups
      • Filegroup backups
      • Differential backups
    • Protecting files and filegroups
    • Recovery considerations for files and filegroups
    • Reducing backup size and time by using read-only filegroups (SQL Server 2005 or later)
    • Recovery factors
      • Transaction logs
      • Recovery strategies
      • Backing up the transaction log
      • Differential backups
      • File and filegroup backups
      • Database recovery
      • Staging recovery
  • Performing backups and restores of SQL Server
    • Overview of using NetBackup for SQL Server
    • Using dbbackex
      • Using client-based schedulers with dbbackex
    • Selecting the SQL host and instance
    • Using the NetBackup for SQL Client interface
    • Starting the NetBackup SQL Client for the first time
    • Backup Microsoft SQL Server Objects field descriptions
    • Backing up databases
    • Backing up transaction logs
    • Backing up database filegroups
    • Backing up read-only filegroups (SQL Server 2005 or later)
      • Viewing read-only backup sets
    • Backing up read-write filegroups (SQL Server 2005 or later)
    • Backing up database files
    • Performing partial backups (SQL Server 2005 or later)
    • Browsing for backup images
    • Restore Microsoft SQL Server Objects field descriptions
    • Restoring a database backup
    • Staging a full database recovery
    • Restoring filegroup backups
    • Recovering a database from read-write backups
    • Restoring read-only filegroups (SQL Server 2005 or later)
    • Restoring database files
    • Restoring a transaction log image without staging a full recovery
    • Performing a database move
    • Restoring partial databases (SQL Server 2000)
    • Performing page-level restores (SQL Server 2005 or later)
      • About performing page-level restores
      • Requirements and limitations
      • Instructions for performing page-level restores
    • Redirecting a restore to a different host
    • Redirecting a database to a different location on a different host
      • About selecting a server
    • Performing restores with a multi-NIC connection
    • Backing up and restoring the databases that contain full-text search catalogs (SQL Server 2005 or later)
      • Full-text catalog directory structure
      • Backing up and restoring the databases that contains full-text catalogs
      • Moving a database that contains full-text catalogs
    • Using batch files
      • Text format used in batch files
      • Guidelines for creating and using batch files
      • Notes when creating and using batch files
      • Keywords and values used in batch files
      • Creating a batch file
      • Running batch files
    • File checkpointing
    • Automatic retry of unsuccessful backups
    • Performing backups and restores of remote SQL Server installations
    • Restoring multistreamed backups
      • Conventional backups using multiple streams
      • Advanced backup methods using multiple streams
      • Restoring a multiplexed SQL Server backup
      • Restoring a multistreamed SQL Server backup with fewer devices than it was backed up with
    • Using bplist to retrieve SQL Server backups
      • Backup names
  • Disaster recovery
    • About disaster recovery
    • Preparing for disaster recovery of SQL Server
    • Disaster recovery of SQL Server
    • Restoring an existing installation of SQL Server with other active databases
    • Disaster recovery of SQL Server databases
      • Rebuilding the master database
      • Starting SQL Server in single-user mode
      • Restoring the SQL Server databases
  • Using NetBackup for SQL Server with clustering solutions
    • Overview of NetBackup for SQL Server with clustering solutions
    • About using NetBackup for SQL in a cluster
    • Configuring the NetBackup server to be aware of clustered SQL Server instances
    • Performing a backup on a virtual SQL Server instance
    • Performing a restore on a virtual SQL Server instance
    • Using SQL Server in a cluster with a multi-interface network connection (multi-NIC)
    • Master server configuration for a SQL Server in a cluster with a multi-NIC
    • Configuring a policy for a SQL Server in a cluster with a multi-NIC
    • Adding the permissions that allow for browsing of backups across the private interface in a cluster
    • Configuring clients for a SQL Server in a cluster with a multi-NIC
      • Specifying the private name of the client for a SQL Server in a cluster with a multi-NIC
    • Performing backups in a cluster with a multi-NIC connection
    • Performing restores in a cluster with a multi-NIC connection
  • Using NetBackup for SQL Server with Snapshot Client
    • About NetBackup for SQL Server with Snapshot Client
    • NetBackup Snapshot Client for SQL Server overview
      • Snapshot Client features
    • How SQL Server operations use Snapshot Client
      • Selection of backup method
      • Limitations
      • What is backed up
      • Performance considerations
      • Performing SQL Server snapshot backups
      • Performing SQL Server snapshot restores
      • Grouped backups
        • Requirements
        • Viewing the progress of a grouped backup
      • Restoring a database backed up in a group
      • Using copy-only or cloaked snapshot backups to affect how differentials are based
        • Sample backup schedule using cloaked backups
        • Creating a cloaked backup (SQL Server 2000)
        • Creating a copy-only backup (SQL Server 2005 or later)
        • Creating a PFI snapshot that is not copy-only
    • Configuring a snapshot backup
      • Configuration requirements
      • Configuration steps
      • Configuring Snapshot Client policies for NetBackup for SQL Server
        • Configuring a Snapshot Client policy
        • Configuring a policy for instant recovery
  • Backups and restores in an SAP environment
    • About backups and restores in an SAP environment
      • About manual backups
      • About policy configuration for SQL Server in an SAP environment
      • Creating batch files for automatic backups in for SQL Server in an SAP environment
        • Creating a batch file for database backups
        • Creating a batch file for transaction log backups
      • Monitoring backups
      • Restoring the R/3 database
        • About including differential backups in a restore operation
        • Restoring the R/3 database after a disk crash
        • Restoring the database backups and transaction log backups
  • Backup Exec restore topics
    • Using NetBackup to restore SQL Server from Backup Exec images
      • Requirements for restoring SQL Server from Backup Exec images
      • Limitations when restoring SQL Server from Backup Exec images
    • Specifying the server, client, and policy type
    • Restoring from Backup Exec images
    • Microsoft SQL Server tab field descriptions
    • Restoring Backup Exec SQL transaction logs up to a named transaction
    • Redirecting a restore that was backed up with Backup Exec
    • Restoring Backup Exec SQL transaction logs backups up to a point in time
    • Restoring the SQL master database from a Backup Exec image
    • Restarting SQL using database copies
    • Restoring Backup Exec filegroup backups
    • Restoring Backup Exec Database backups
  • Using NetBackup for SQL Server with database mirroring
    • About NetBackup for SQL Server with database mirroring
    • Configuring NetBackup to support database mirroring
    • Effect on backup
    • Effect on recovery
  • Troubleshooting
    • Overview of troubleshooting
    • Progress reports created for NetBackup for SQL Server on the client
    • Sample progress report
    • Debug logging
      • Creating all debug logs
      • About backup operation debug logging
      • About restore operation debug logging
    • Setting the maximum trace level for NetBackup for SQL Server
    • NetBackup reports
    • Minimizing timeout failures on large database restores
  • Sample batch files
    • About sample batch files
      • Sample 1 - Simple script to back up a database named BUSINESS
      • Sample 2 - Simple script to restore a database named pubs
      • Sample 3 - Perform a striped database backup. allow multiple internal buffers per stripe
      • Sample 4 - Restore a database from multiple stripes
      • Sample 5 - Restore a database transaction log up to a point in time
      • Sample 6 - Perform an operation and specify the user ID and password to use to SQL Server
      • Sample 7 - Perform multiple operations in sequence
      • Sample 8 - Perform a set of operations in parallel
      • Sample 9 - Specify the maximum transfer size and block size for a backup
      • Sample 10 - Stage a database restore from a database backup, a differential backup, and a series of transaction backups
      • Sample 11 - Stage a database restore from a filegroup backup, several file backups, and transaction log backups
      • Sample 12 - Using environment variables to exclude instances and databases from backup
  • Reference:Dialog box fields
    • Backup History Options field descriptions
    • Manage Scripts field descriptions
    • NetBackup client properties field descriptions
    • Viewing properties of objects selected for restore
      • Backup properties tab
      • About the Recovery set tab
      • About the Read-only backup set tab
    • About selecting database objects for restore
    • SQL Server connection properties
    • Microsoft SQL Server Redirection tab
    • Microsoft SQL Server tab
    • Microsoft SQL Server Redirection tab field descriptions
    • SQL Server connection properties field descriptions