Configure Agent Behavior for Databases Ineligible for Backup
96 Agent for Microsoft SQL Server Guide
Configure Agent Behavior for Databases Ineligible for
Backup
The Agent for Microsoft SQL Server has a pre-defined set of rules that governs
how databases ineligible for backup are recognized and handled. Backup
eligibility is determined by database status and other properties. CA ARCserve
Backup posts an error or warning and marks the job as Failed or Incomplete,
depending on the following factors:
■
why the database is ineligible
■
how the database was selected for backup (explicitly or implicitly)
The following information organized by database status is provided to help you
recognize default behavior and, if needed, change the default responses by
adding controller values to the Agent settings in the Windows Registry on the
computer on which the CA ARCserve Backup Agent for Microsoft SQL Server is
installed. For each database status, the default behavior is listed for each
selection type, as well as the setting name that changes it. The procedure for
creating and setting DWORDS follows the table.
Database Status
If Database is
Selected
If Whole Instance is
Selected
Standby (read-only,
waiting to receive
additional restores)
Message Type: Error
Job Result: Failure
Setting Name: Standby
Explicit
Message Type: Warning
Job Result: Successful
Setting Name: Standby
Implicit
Mirror (SQL 2005 or later)
Failover Mirroring
Message Type:
Warning
Job Result: Incomplete
Setting Name: Mirror
Explicit
Message Type: n/a
Job Result: Successful
Setting Name: Mirror
Implicit
Suspect (damaged or
missing files) using Simple
Recovery Model
Message Type: Error
Job Result: Failure
Setting Name: Suspect
Explicit
Message Type: Error
Job Result: Failure
Setting Name: Suspect
Implicit
Off-line
Message Type: Error
Job Result: Failure
Setting Name: Offline
Explicit
Message Type: Error
Job Result: Failure
Setting Name: Offline
Implicit
Loading
Message Type: Error
Job Result: Failure
Setting Name: Loading
Message Type: Error
Job Result: Failure
Setting Name: Loading