Backup Overview
34 Agent for Microsoft SQL Server Guide
■
For databases that have not yet received a Database Full backup, CA
ARCserve Backup ignores the backup method set in the Global Agent Options
tab and performs a full backup by default.
■
For databases using the Simple Recovery Model, CA ARCserve Backup
performs a Differential backup when you choose Transaction Log Only on the
Global Agent Options tab.
Because any selection other than Use Global or Rotation Method for a database
overrides the selection in the Global Agent Options dialog, the Backup Method is
not affected by the Override Global Options setting on the database's Agent
Options (database level) dialog.
Database Subset
Database Subset options let you define the types of database components that
you want to back up. You can use this option to choose between the entire
database, or a selection of files and FileGroups contained within the database,
when the size of the database and performance requirements do not allow you to
back up the entire database.
Database Subset options are disabled if the selected Backup Method for a
database is Transaction Log Only.
Important!
Of the following Database Subset options, only the Back up
Transaction Log After Database option is available on the Global Options/Agent
Options dialog.
■
Entire Database-
-Backs up the entire database.
■
Files and FileGroups--
Backs up selected files in a database. Use this
option to back up a file or FileGroup when the database size and performance
requirements make it impractical to perform a full database backup. This
option is only available for databases using the Full and Bulk-Logged
Recovery Models.
Note:
For Microsoft SQL Server 7.0 databases, CA ARCserve Backup
performs a Files and FileGroups Full backup if you set the database subset to
Files and FileGroups for the database level and backup method to Differential
on the Global Agent Options tab.
■
Partial Database--
Backs up the Primary FileGroup, and any other
Read-Write FileGroups. For a Read-Only database, only the Primary
FileGroup will be backed up. This option requires SQL Server 2005 or later.
■
Back up Transaction Log After Database--
Backs up the Transaction Log
after the database, partial database, or selected set of data files is backed
up. This allows you to perform both a Full or Differential backup and a
Transaction Log backup in the same job. This option is only available for
databases using the Full and Bulk-Logged Recovery Models and is ignored for
databases using the Simple Recovery Model if set in the Global Agent
Options dialog.
