Introducing the Agent › How the Agent Works › Backup and Restore Options

Backup and Restore Options

Backup options enable you to do the following:

• Perform a Full or Differential backup of a database
• Back up the entire database, a selected set of files and FileGroups within a database, or an automatically-selected set of FileGroups that contain changeable data
• Back up the transaction log of a database, with or without truncating the log
• Take the database offline automatically after a transaction log backup, leaving it in a restoring state
• Check the consistency of databases before and after backup
• Perform both a Data and Transaction Log backup of a database in a single backup job
• Include SQL Server's native error checking information as part of the backed-up data

For more information about backup options, see the section, Backing Up Microsoft SQL Server Databases.

Restore options enable you to do the following:

• Restore data and transaction logs
• Automatically determine a sequence of backups to restore, to produce a live, consistent database with a single restore job
• Use transaction log restores to restore the data to a specific point in time, or to the start or end of a named transaction
• Restore the entire database or a selected subset of the database files and FileGroups
• Restore a selected subset of the database as a new database
• Perform a Torn Page Repair of a database, even while it is online
• Leave the database in a restricted access mode
• Preserve or clear the replication settings of the restored database
• Change the physical location on disk of data and transaction log files
• Check only the physical consistency of a database after restore is complete
• Override any inconsistencies found with SQL Server's native error checking information

For more information about restore options, see the section, Restoring Microsoft SQL Server Databases.

Microsoft SQL - CA ARCserve Backup Compatibility Matrix

CA ARCserve Backup supports features and functions introduced in various Microsoft SQL Server versions, as follows: