Using Tivoli Data Protection for Microsoft SQL Server

TOP : IBM TotalStorage Redbooks

Using Tivoli Data Protection for Microsoft SQL Server

This IBM Redbook explains how to use Tivoli Data Protection (TDP) for Microsoft SQL Server v.2.2 to perform backups and restores in your SQL environment. Tivoli Data Protection for Microsoft SQL Server performs online backups of Microsoft SQL Server databases to Tivoli Storage Manager (TSM) storage. We demonstrate how to back up and recover data on SQL 7.0 as well as SQL 2000 on a single server installation and a clustered environment. Windows 2000 (Service Pack 1) is used as the operating system and SQL 7.0 as well as SQL 2000. However, we do not cover backing up the operating system itself.

Version 2.2 provides new functionality as well as support for one of the important features of Tivoli Storage Management: automatic expiration and version control by policy. We demonstrate how this frees users from having to explicitly delete backup objects in the Tivoli Storage Manager server.

TDP for SQL also supports LAN-free environments. We demonstrate how to use TDP for SQL to perform backups across a traditional LAN as well as utilizing TSM LAN-free to support backups across Storage Area Networks (SANs).

This book is written for SQL server administrators as well as TSM administrators with a need to understand the issues and considerations pertinent to utilizing TSM and TDP to back up and restore Microsoft SQL server.
Price: $35.00 $28.00
Pages: 178
Date Published: May 22, 2001
ISBN: 0738421995
Author: IBM Redbooks
Product Number: SG24-6148-00
Ships in 3-5 days
Return to category
Why Vervante?

© 2024 Vervante Corporation. All rights reserved.