SSER7G_8.2.2 - Documentation Index

Table of Contents

• Welcome
• What's new
  • Release notes for Data Protection for Oracle 8.2
  • Release notes for Data Protection for Microsoft SQL Server 8.2
• Data Protection for Microsoft SQL Server
  • Getting Started
    • Environment overview
    • Failover clustering and AlwaysOn Availability
      • Availability database backup operations
      • Availability database restore operations
      • Data Protection for AlwaysOn Availability Groups
      • Automated IBM Storage Protect server failover for data recovery
    • Data backup overview
      • VSS data backups
        • Protection in VSS environments
          • VSS backup characteristics
          • VSS backup requirements
          • VSS restore characteristics
          • VSS restore requirements
          • VSS operations in IBM N-series and NetApp environments
        • Data Protection for SQL Server with IBM SAN Volume Controller and IBM Storwize V7000
          • IBM System Storage requirements
      • Offloaded VSS backups
      • SQL Server legacy backups
      • Database backup types
      • Policy management for backups
        • How backups expire based on policy
        • How policy affects backup management on Data Protection for SQL Server
        • Preferred settings for IBM Storage Protect policies
        • Creating a local backup policy
        • Specifying policy binding statements
        • Binding backups to a policy
        • VSSPOLICY statements for backup types
    • Data restore overview
      • VSS fast restore processing
      • VSS instant restore processing
  • Planning
  • Installing, upgrading, and migrating
    • Prerequisites
    • Quick installation and configuration of Data Protection for SQL Server
    • Installing on a local system
    • Silently installing Data Protection for SQL Server
      • Options in silent installations
      • Creating and testing a silent installation package on a DVD or a file server
      • Batch files usage in silent installations
      • Silent installation error messages
    • Installing in a cluster environment
    • Silently installing Data Protection for SQL Server on Windows Server Core
      • Installing the IBM Storage Protect client
      • Silent installation of Data Protection for SQL Server on Windows Server Core with the setup program
      • Silent installation on Windows Server Core with the Microsoft Installer program
    • Validating the digital signature of the client package on Data Protection for Data Protection for SQL Server
    • Upgrading Data Protection for SQL Server
    • Migrating Data Protection for Exchange ServerData Protection for SQL ServerIBM Storage Protect Snapshot
  • Configuring
    • Specifying configuration parameters for IBM Storage Protect
    • Specifying Data Protection for SQL Server node name parameters
    • Specifying Data Protection for SQL Server configuration and options files in non-default locations
    • Configuring proxy relationships for VSS backups
      • Required node names for basic VSS operations
      • Required node names for basic VSS offloaded backups
    • Setting user preferences
      • Data Protection properties
        • Server Information
        • Server Password
        • Policy Management
        • VSS Policy Binding
        • Managed Capacity
        • Diagnostics
        • SQL Login
        • General (SQL)
        • Logging
        • Regional
        • VSS Options
        • Custom Settings
        • AlwaysOn Node
        • AlwaysOn Preferences
        • Performance
    • Configuring by using the IBM Storage Protect Configuration Wizard
    • Configuring a remote system with an IBM Storage Protect configuration
    • Configuring IBM Storage Protect policy to set automatic expiration and version control (VSS and legacy backups)
    • Configuring in a clustered environment
      • Configuring Data Protection for SQL Server with IBM Storage Protect in a clustered environment
      • Configuring VSS operations in a clustered environment
      • Configuring availability replicas to run scheduled data backups
    • Manually configuring Data Protection for SQL Server
      • Configuring the computer that runs the SQL Server
      • Configuring the IBM Storage Protect server
      • Configuring the system that runs the offloaded backups
      • Verifying the configuration of Data Protection for SQL Server
        • Verifying the server configuration from the integrated command line
        • Verifying the SQL Server is ready to start VSS operations
        • Common errors returned from VSS backup operations
    • Manually configuring Data Protection for SQL Server on Windows Server Core
      • Creating a node on the IBM Storage Protect server
      • Setting up a proxy node for offloaded VSS backups in the Windows Server Core environment
      • Configuring the client in the Windows Server Core environment
      • Configuring Data Protection for SQL Server on Windows Server Core
      • Changing Data Protection for SQL Server configuration values on Windows Server Core
    • Transitioning SQL Server backups from IBM Storage Protect Snapshot to IBM Storage Protect
    • Transitioning standard SQL Server databases to the AlwaysOn node
    • Examples of IBM SAN Volume Controller and IBM Storwize V7000 configuration scenarios
  • Protecting data
    • Prerequisites
    • Choosing your backup strategy
    • Starting Microsoft Management Console
    • Starting the command-line interface
      • Getting help for Data Protection for SQL Server commands
    • Managing Data Protection for SQL Server installations remotely
    • Determining managed storage capacity
    • Managing backup, restore, and automation tasks in the Task Manager
    • Backing up SQL Server data
      • Quick guide
      • Creating legacy backups of SQL Server databases
        • Creating legacy backups of SQL Server groups or files
      • Creating VSS backups of SQL Server databases
      • Enabling SQL Server backup compression
      • Verifying the integrity of legacy databases by using the checksum option
      • Backing up SQL Server databases on Windows Server Core
      • Deleting SQL Server backups
      • Deactivating legacy backups of SQL Server databases
      • Mounting VSS snapshots to remote servers
      • Mounting SQL Server backups
    • Restoring SQL Server databases and files
      • Setting single-user mode for restore operations
      • Setting data restore options in Microsoft Management Console
      • Restoring SQL Server data
      • Restoring an SQL Server database to an alternative instance
      • Restoring the master database
      • Restoring SQL Server databases with full-text catalogs and indexes
      • Restoring SQL Server databases from virtual machine snapshots
      • Restoring SQL Server databases on Windows Server Core
      • Restoring SQL Server file groups and files from legacy backups
    • Protecting SQL Server data in a failover cluster environment
      • Data Protection for AlwaysOn Availability Groups
      • Creating SQL Server backups in AAG environment
      • Example backup scenarios
    • Protecting SQL Server data in a Windows Server Core environment
      • Backing up SQL Server databases on Windows Server Core
      • Restoring SQL Server databases on Windows Server Core
      • Changing Data Protection for SQL Server configuration values on Windows Server Core
    • Viewing, printing, and saving reports
  • Automating
    • Preparing to use Windows PowerShell cmdlets with Data Protection for SQL Server
      • Cmdlets for Microsoft Management Console
      • Cmdlets for protecting Microsoft SQL Server data
    • Automating tasks
    • IBM Storage Protect task scheduler
  • Troubleshooting
    • Diagnosing problems
      • Error log files
      • Determining that the problem is a Data Protection for SQL Server issue or a general VSS issue
      • Running Must-Gather scripts
    • Resolving reproducible problems
      • Troubleshooting VSS backup and restore operations
      • Troubleshooting VSS and SAN Volume Controller, Storwize V7000, or DS8000
    • Resolving problems with IBM Support
      • Gathering trace and log files for Data Protection for SQL Server
      • Gathering installation log files to debug installation problems
      • Gathering traces for the Data Protection client when using VSS technology
      • Gathering information about SQL Server with VSS before you call IBM
      • Gathering files from SQL Server with VSS before calling IBM
      • Viewing and modifying system information for Data Protection for SQL Server
      • Sending support files by email
      • Online IBM support for Data Protection for SQL Server
  • Performance tuning
    • Buffering (Legacy only)
    • Data striping (Legacy only)
    • LAN-free data movement (Legacy and VSS)
  • Reference
    • Command-line overview
    • Data Protection for SQL Server parameters by backup method
    • Backup command
      • Backup syntax
      • Backup positional parameters
      • Backup optional parameters
      • Legacy backup examples
      • VSS backup examples
    • Changetsmpassword command
      • Changetsmpassword
      • Changetsmpassword positional parameters
      • Changetsmpassword optional parameters
      • Changetsmpassword output examples
    • Delete Backup command
      • Delete Backup syntax
      • Delete Backup positional parameters
      • Delete Backup optional parameters
      • Delete Backup example
    • Help command
      • Help syntax
      • Help positional parameters
      • Help output examples
    • Inactivate command (Legacy only)
      • Inactivate syntax
      • Inactivate positional parameters
      • Inactivate optional parameters
      • Inactivate output examples
    • Mount Backup command
      • Mount Backup syntax
      • Mount backup positional parameter
      • Mount Backup optional parameters
    • Query command
      • Query syntax
      • Query positional parameters
      • Query optional parameters
      • Query output examples
    • Query Managedcapacity command
    • Query Policy command
    • Restore command
      • VSS restore command-line considerations
      • Restore syntax
      • Restore positional parameters
      • Restore optional parameters
      • Legacy restore output examples
      • VSS restore output examples
    • Restorefiles command
      • Restorefiles syntax
      • Restorefiles positional parameters
      • Restorefiles optional parameters
      • Restorefiles examples
    • Set command
      • Set syntax
      • Set positional parameters
      • Set optional parameters
      • Set output examples
    • Unmount Backup command
      • Unmount Backup syntax
      • Unmount Backup positional parameter
      • Unmount Backup optional parameters
    • Frequently asked questions
  • ACO messages
    • Data Storage for Microsoft SQL Server messages format
    • Data Storage for Microsoft SQL Server messages
      • ACO messages
        • ACO0003S
        • ACO0004E
        • ACO0005E
        • ACO0053E
        • ACO0054E
        • ACO0055E
        • ACO0056E
        • ACO0057E
        • ACO0058E
        • ACO0100E
        • ACO0101E
        • ACO0102E
        • ACO0103E
        • ACO0104E
        • ACO0105E
        • ACO0132W
        • ACO0133W
        • ACO0134W
        • ACO0150I
        • ACO0151E
        • ACO0152I
        • ACO0153I
        • ACO0154E
        • ACO0155E
        • ACO0156E
        • ACO0160E
        • ACO0161E
        • ACO0162E
        • ACO0163E
        • ACO0167E
        • ACO0200E
        • ACO0201E
        • ACO0202E
        • ACO0203E
        • ACO0204E
        • ACO0205E
        • ACO0206E
        • ACO0207E
        • ACO0208E
        • ACO0209E
        • ACO0210E
        • ACO0211E
        • ACO0212E
        • ACO0213E
        • ACO0214E
        • ACO0215E
        • ACO0216E
        • ACO0217E
        • ACO0218E
        • ACO0219E
        • ACO0256E
        • ACO0257E
        • ACO0258E
        • ACO0259E
        • ACO0260I
        • ACO0261I
        • ACO0262E
        • ACO0267E
        • ACO0292E
        • ACO0300E
        • ACO0301E
        • ACO0351E
        • ACO0368E
        • ACO0383E
        • ACO0384E
        • ACO0385E
        • ACO0476E
        • ACO0480I
        • ACO0487E
        • ACO0488E
        • ACO0495E
        • ACO0496I
        • ACO0497I
        • ACO0498I
        • ACO0501E
        • ACO0515E
        • ACO0516I
        • ACO0517I
        • ACO0518E
        • ACO0519E
        • ACO0520E
        • ACO0521E
        • ACO0522E
        • ACO0524S
        • ACO0555E
        • ACO0556E
        • ACO0571E
        • ACO0572E
        • ACO0573E
        • ACO0574E
        • ACO0575E
        • ACO0576I
        • ACO0581E
        • ACO0583E
        • ACO0585E
        • ACO0588E
        • ACO0589E
        • ACO0590E
        • ACO0591I
        • ACO0592E
        • ACO0593E
        • ACO0594E
        • ACO0595E
        • ACO0598E
        • ACO0599E
        • ACO0601E
        • ACO0602E
        • ACO0603S
        • FMF0604E
        • FMF0605E
        • FMF0606E
        • FMF0607E
        • FMF0608E
        • FMF0609E
        • ACO0649E
        • ACO0650E
        • ACO1225E
        • ACO1226E
        • ACO1227E
        • ACO3000I
        • ACO3001I
        • ACO3002E
        • ACO3003I
        • ACO3004I
        • ACO3005E
        • ACO3006I
        • ACO3007I
        • ACO3008I
        • ACO3009I
        • ACO3010I
        • ACO3011I
        • ACO3012I
        • ACO3013I
        • ACO3014I
        • ACO3015I
        • ACO3016I
        • ACO3528E
        • ACO3532E
        • ACO4354E
        • ACO5050I
        • ACO5051I
        • ACO5052E
        • ACO5053E
        • ACO5054I
        • ACO5056I
        • ACO5057I
        • ACO5058W
        • ACO5059W
        • ACO5060E
        • ACO5061E
        • ACO5063I
        • ACO5064W
        • ACO5065E
        • ACO5091E
        • ACO5097I
        • ACO5098E
        • ACO5124E
        • ACO5125E
        • ACO5126E
        • ACO5127E
        • ACO5128E
        • ACO5129E
        • ACO5170E
        • ACO5171E
        • ACO5172E
        • ACO5186E
        • ACO5188E
        • ACO5195I
        • ACO5196I
        • ACO5197I
        • ACO5198W
        • ACO5204E
        • ACO5205E
        • ACO5400E
        • ACO5401E
        • ACO5402E
        • ACO5403E
        • ACO5404E
        • ACO5405E
        • ACO5406E
        • ACO5407E
        • ACO5421E
        • ACO5422E
        • ACO5423E
        • ACO5424E
        • ACO5425E
        • ACO5426E
        • ACO5428E
        • ACO5429E
        • ACO5430E
        • ACO5431E
        • ACO5432E
        • ACO5433E
        • ACO5434E
        • ACO5435E
        • ACO5436E
        • ACO5450E
        • ACO5452E
        • ACO5453E
        • ACO5454E
        • ACO5455E
        • ACO5456W
        • ACO5457E
        • ACO5458W
        • ACO5459W
        • ACO5460W
        • ACO5500E
        • ACO5501E
        • ACO5550I
        • ACO5551I
        • ACO5552I
        • ACO5616W
        • ACO5617I
        • ACO5629E
        • ACO5630E
        • ACO5631E
        • ACO5715E
        • ACO5716W
        • ACO5717E
        • ACO5718I
        • ACO5719I
        • ACO5720I
        • ACO5721I
        • ACO5722I
        • ACO5723E
        • ACO5770E
        • ACO5784E
        • ACO5804I
        • ACO5915E
        • ACO5958W
        • ACO5959E
        • ACO5960E
        • ACO5961E
        • ACO5965E
        • ACO5966E
        • ACO5969E
        • ACO6060I
        • ACO6065E
        • ACO6066E
        • ACO6067E
        • ACO6101I
        • ACO6103I
        • ACO6104I
        • ACO6105I
        • ACO6110W
        • ACO6111I
        • ACO6112W
        • ACO6113I
        • ACO6114W
        • ACO6115I
        • ACO6116I
        • ACO6117I
        • ACO6200W
        • ACO6201W
        • ACO6202W
        • ACO6203I
        • ACO6204I
        • ACO6205E
        • ACO6206W
        • ACO6209W
        • ACO6210W
        • ACO6211E
        • ACO6212I
        • ACO6213E
        • ACO6214W
        • ACO6215E
• Data Protection for Oracle
  • Protection for Oracle Server databases
    • Overview of Data Protection for Oracle
      • RMAN and Data Protection for Oracle
      • LAN-free data transfer
      • Migration and coexistence
      • Automated failover for data recovery
  • Installing, Uninstalling, and Upgrading
    • Installing and upgrading Data Protection for Oracle
      • Installation prerequisites
        • Minimum hardware requirements
        • Minimum software and operating system requirements in an AIX and Linux environment
      • Installing on an AIX 64-bit operating system
        • Installing Data Protection for Oracle in silent mode
      • Installing on a 64-bit HP-UX Itanium system
      • Installing on a Linux x86_64 system
      • Installing on a Linux on System z system
      • Installing on a Solaris SPARC or Solaris x86 system
      • Upgrading Data Protect for Oracle on Linux
      • Upgrading Data Protection for Oracle on Solaris 11
      • Upgrading Data Protection for Oracle on AIX 7.3
    • Installing Data Protection for Oracle in a Windows environment
      • Installation prerequisites
        • Minimum hardware requirements
        • Minimum software and operating system requirements
      • Installing in a Windows environment
      • Installing Data Protection for Oracle in silent mode
        • Installing in silent mode with the setup executable file
        • Installing in silent mode with MSI
        • Capturing a log of the installation
        • Creating an installation package
          • Creating a package for installing in silent mode
        • Playing back the installation package in silent mode
        • Creating batch files for installing in silent mode
    • Uninstalling Data Protection for Oracle
      • Uninstalling Data Protection for Oracle on Solaris 11 and Linux on system Z
      • Uninstalling Data Protection for Oracle on AIX
    • Validating the digital signature of the client package on Data Protection for Oracle
  • Configuring Data Protection for Oracle
    • Configuration with default settings
    • Configuring Data Protection for Oracle
      • Define Data Protection for Oracle options in the tdpo.opt file
        • Options
      • Register the Data Protection for Oracle node to an IBM Storage Protect server
      • Define IBM Storage Protect options in the client options file
        • Required options
        • Other configuration options to consider
      • Define IBM Storage Protect policy requirements
      • Initialize the password with an IBM Storage Protect server
  • Protecting Oracle Server data
    • RMAN and Data Protection for Oracle
      • Starting RMAN
      • Editing RMAN scripts
        • Sending options with the send command
        • RMAN script examples
      • The Duplex Copy function
      • Removing old backups
        • Removing a backup example
    • Setting up a schedule example
      • Setting up a schedule on the IBM Storage Protect server
      • Setting up a schedule on the client machine NodeA1
      • Setting up a schedule on the workstation with the Oracle Server (Windows)
    • Querying backup objects
    • Data deduplication with Data Protection for Oracle
      • Overview of data deduplication
      • Setting up for client-side data deduplication
      • Determining total data reduction
  • Commands and utilities for Data Protection for Oracle
    • tdpoconf and tdposync utilities
      • Command line syntax and characteristics
      • tdpoconf utility
        • Password command
        • Showenvironment command
      • tdposync utility
        • tdposync considerations
        • syncdb command
          • PICK window
        • Query command
  • Troubleshooting
    • Diagnosing problems
      • Running Must-Gather scripts
  • ANU messages
    • Data Protection for Oracle messages format
    • Data Protection for Oracle messages
      • ANU messages
        • ANU0003S
        • ANU0004E
        • ANU0005E
        • ANU0053E
        • ANU0054E
        • ANU0055E
        • ANU0056E
        • ANU0057E
        • ANU0058E
        • ANU0100E
        • ANU0101E
        • ANU0102E
        • ANU0103E
        • ANU0104E
        • ANU0105E
        • ANU0132W
        • ANU0133W
        • ANU0134W
        • ANU0150I
        • ANU0151E
        • ANU0152I
        • ANU0153I
        • ANU0154E
        • ANU0155E
        • ANU0156E
        • ANU0160E
        • ANU0161E
        • ANU0162E
        • ANU0163E
        • ANU0167E
        • ANU0200E
        • ANU0201E
        • ANU0202E
        • ANU0203E
        • ANU0204E
        • ANU0205E
        • ANU0206E
        • ANU0207E
        • ANU0208E
        • ANU0209E
        • ANU0210E
        • ANU0211E
        • ANU0212E
        • ANU0213E
        • ANU0214E
        • ANU0215E
        • ANU0216E
        • ANU0217E
        • ANU0218E
        • ANU0219E
        • ANU0256E
        • ANU0257E
        • ANU0258E
        • ANU0259E
        • ANU0260I
        • ANU0261I
        • ANU0262E
        • ANU0267E
        • ANU0292E
        • ANU0300E
        • ANU0301E
        • ANU0351E
        • ANU0368E
        • ANU0383E
        • ANU0384E
        • ANU0385E
        • ANU0476E
        • ANU0487E
        • ANU0488E
        • ANU0495E
        • ANU0496I
        • ANU0497I
        • ANU0498I
        • ANU0501E
        • ANU0515E
        • ANU0516I
        • ANU0517I
        • ANU0518E
        • ANU0519E
        • ANU0520E
        • ANU0521E
        • ANU0522E
        • ANU0524S
        • ANU0555E
        • ANU0556E
        • ANU0571E
        • ANU0572E
        • ANU0573E
        • ANU0574E
        • ANU0575E
        • ANU0576I
        • ANU0581E
        • ANU0583E
        • ANU0585E
        • ANU0588E
        • ANU0589E
        • ANU0590E
        • ANU0591I
        • ANU0592E
        • ANU0593E
        • ANU0594E
        • ANU0595E
        • ANU0598E
        • ANU0599E
        • ANU0601E
        • ANU0602E
        • ANU0603S
        • FMF0604E
        • FMF0605E
        • FMF0606E
        • FMF0607E
        • FMF0608E
        • ANU0649E
        • ANU0650E
        • ANU2500E
        • ANU2501E
        • ANU2502E
        • ANU2503E
        • ANU2504E
        • ANU2505I
        • ANU2506E
        • ANU2507E
        • ANU2508E
        • ANU2509E
        • ANU2510E
        • ANU2511E
        • ANU2512E
        • ANU2513E
        • ANU2514E
        • ANU2515E
        • ANU2516E
        • ANU2517E
        • ANU2518E
        • ANU2519E
        • ANU2521E
        • ANU2522E
        • ANU2523E
        • ANU2525E
        • ANU2526I
        • ANU2527I
        • ANU2529E
        • ANU2530E
        • ANU2531E
        • ANU2532E
        • ANU2533E
        • ANU2534E
        • ANU2535I
        • ANU2536I
        • ANU2537E
        • ANU2538E
        • ANU2539E
        • ANU2571E
        • ANU2575E
        • ANU2576E
        • ANU2600E
        • ANU2601E
        • ANU2602E
        • ANU2603E
        • ANU2604W
        • ANU2610W
        • ANU2612W
        • ANU2613E
        • ANU2614E
        • ANU2615E
        • ANU2616E
        • ANU2617E
        • ANU2620E
        • ANU2621E
        • ANU2622E
        • ANU2623I
        • ANU2627W
        • ANU2628W
• Compatibility matrix
• PDF files
• Glossary