Use Tivoli® Storage
Manager for
Databases: Data Protection for Microsoft SQL
Server to protect business-critical databases with automated tasks,
utilities, and interfaces.
Getting started
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. The term
local shadow volumes describes data that is
stored on shadow volumes, which are localized to a disk storage subsystem.
Planning
Before you implement your VSS backup and restore strategies, review the security requirements and other guidelines that are specific to your environment. Consider how to manage your Tivoli Storage Manager policy, and set available Data Protection for SQL Server configuration options and preferences.
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 SQL Server data by using the Microsoft Management Console (MMC) or the command-line
interface. If required, you can manage your Data Protection for SQL Server installations
remotely.
Automating
With Data Protection for SQL Server automation capability, you can run commands from the command line, create scripts, schedule tasks, and use the 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 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 the Microsoft Management Console (MMC).