Restore Options
Chapter 4: Restoring Microsoft SQL Server Databases 47
Automatic Selection Option
The Automatic Selection option automatically:
■
Selects other sessions that must be restored with the session you are
restoring for the restore job to be successful
■
Applies selected options appropriately to the automatically selected sessions
The Automatic Selection option is enabled by default for every restore job. Using
Automatic Selection saves you time and prevents errors in packaging restore
jobs.
Important!
Using Automatic Selection, you may be unable to restore a
database to a different location on a disk (for example, to a different drive letter
or directory path, or with a different file name) using backups from previous
versions of CA ARCserve Backup or BrightStor
®
Enterprise Backup. For more
information about restoring to a different location, see Restore to Alternative
Disk Locations Using Automatic Selection.
Restore Types
The Agent for Microsoft SQL Server supports the following types of restores:
Database restore
Restores the entire database. If the selected session is a Database
Differential backup or a Partial Full backup, the last prior Database Full
backup is required as a pre-requisite. If the selected session is a Partial
Differential backup, the last Database Full or Partial Full backup is required
as a pre-requisite.
Transaction Log restore
Restores the Transaction log. Restoring a Transaction log is also referred to
as "applying" a Transaction log. When you restore a Transaction log,
Microsoft SQL Server re-executes the changes contained in the log and rolls
back any transactions that were uncommitted when you backed up the
Transaction log.
After restoring a database from a Full Backup, you can load the differential
backup (if any) and the Transaction log backups you created after backing
up that database. Loading Transaction logs lets you to recover as much of a
database as possible.
