By using Microsoft Volume
Shadow Copy Service (VSS), you can back up SQL Server data and mount
the backup if required. You can also create legacy backups of SQL
Server databases, groups, and files.
Enabling SQL Server backup compression
With Data Protection for SQL Server, you
can compress SQL Server backups. Compression reduces
traffic and storage requirements. SQL Server backup compression
is generally faster and more effective than using Tivoli® Storage Manager compression.
Creating legacy backups of SQL Server databases
You can create a legacy backup of your standard SQL Server
databases by using Microsoft Management
Console (MMC). You can also use the legacy method to back up availability
databases with SQL Server 2012 and later versions.
Creating legacy backups of SQL Server groups or files
You can create a legacy backup of SQL Server
groups or files in a normal SQL Server database by using Microsoft Management Console (MMC). You
can also use the legacy method to back up groups of files in availability
databases with SQL Server 2012 and later versions.
Deleting SQL Server backups
You can remove an SQL Server backup that you created with
the VSS backup method. Complete this task only if necessary.
Deactivating legacy backups of SQL Server databases Tivoli Storage
Manager deactivates an SQL Server
database backup as a part of Tivoli Storage
Manager policy
management. Data backups are typically deactivated when an SQL Server database is deleted from the
SQL Server as part of the scheduled backup processing.