How the Agent Works
Chapter 1: Introducing the Agent 15
Access Requirements
When you submit a job that includes Windows database servers, CA ARCserve
Backup prompts you for a system user name and password for the system on
which the database resides. CA ARCserve Backup accesses the remote servers
using this user name and password.
A Microsoft SQL Server native user name and password are also required to
access some database instances. When prompted by the system, enter the
Microsoft SQL Server user ID and the password of the system administrator (sa),
or enter a user ID and password with equivalent privileges. For more information
about agent security configuration, see Configuring Microsoft SQL Server
Security Settings.
Note:
There are two different data transfer mechanisms available to the agent,
and they have different permission requirements. A backup using Named Pipes
only requires the Backup Operator permission for the specific database being
backed up, and the Database Creator role to perform the restore. A backup using
Virtual Devices requires the System Administrator role. However, the Named
Pipes mechanism is available only for Microsoft SQL Server 7.0 and 2000. The
CA ARCserve Backup Agent for Microsoft SQL Server requires Local
Administrator permission in Windows Vista, Windows Server 2008 and later.
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
(see page 29).
