Data Protection for Microsoft SQL Server

Use Tivoli® Storage Manager for Databases: Data Protection for Microsoft SQL Server to protect business-critical databases with automated tasks, utilities, and interfaces.

  • Data Protection for SQL Server updates V7.1.6
    This document provides information about what's new or what has changed in Data Protection for Microsoft SQL Server version 7.1.6.
  • Getting started, planning information
    With Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server software, you can back up and restore Microsoft SQL Server databases to Tivoli Storage Manager storage or local shadow volumes. A local shadow volume contains data that is stored on shadow volumes, which are local to a disk storage system.
  • Installing, upgrading, and migrating
    Before you start the installation process, review the appropriate prerequisite information, including hardware and software requirements.
  • Configuring
    You can use configuration wizards to configure Data Protection for SQL Server, or you can complete the steps manually. For best results, be guided by the step-by-step instructions in the configuration wizards
  • Protecting data
    You can back up and restore your Microsoft SQL Server data by using Microsoft Management Console (MMC) or the command-line interface.
  • Protection of Microsoft SQL Server data in VMware environments
    For Microsoft SQL Server workloads that are running in a VMware ESXi virtual guest machine, you can take application-consistent backups of virtual machines that are hosting Microsoft SQL Server data. By using Tivoli Storage Manager software, you can also recover backups from the virtual machine.
  • Automating
    With Data Protection for SQL Server automation capability, you can run commands from the command line, create scripts, schedule tasks, and use Microsoft Management Console (MMC) to start tasks. The tasks that you can automate are based on the scripts and schedules that you create.
  • Troubleshooting
    Data Protection for SQL Server supports you in protecting Microsoft SQL Server databases. Data Protection for SQL Server uses the Microsoft Server Managed Objects (SMO) application programming interface (API), and the Microsoft Virtual Shadow Copy Service (VSS).
  • Performance tuning
    Many factors can affect the backup and restore performance of Data Protection for SQL Server.
  • Reference information
    Reference information includes the backup and restore commands that you can issue at the command-line interface as an alternative to using Microsoft Management Console (MMC).