Backing Up Data › Global Backup Options › Backup Manager Agent Options › Agent for Microsoft SQL Server Options › Database Subset

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, 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 a Full backup 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.

  Be aware of the following behavior:

  • If you select this option on the Global Options/Agent Options tab and specify Incremental backup method using the Job Scheduler, Arcserve Backup performs only one transaction log backup on the database and uses the Transaction Log Truncation Options from the Global Agent Options tab instead of the Incremental backup's default behavior (truncate the transaction log).
  • If you select this option using the Database Level Agent options, set the backup method at the database level to Use Global or Rotation, and set the backup method in the Global Agent Options to Transaction Log Only, Arcserve Backup performs only one transaction log backup on the database and uses the Transaction Log Truncation Options set from the database level.
  • If you select this option in the Global Agent Options dialog and specify Transaction Log Only in Database Level Options, this option and the accompanying global Log Truncation Options setting is ignored for that database.