Configure Agent Behavior for Databases Ineligible for Backup
Appendix A: Troubleshooting and Disaster Recovery 97
Database Status
If Database is
Selected
If Whole Instance is
Selected
Explicit
Implicit
Recovering (in the middle
of processing restored
data)
Message Type: Error
Job Result: Failure
Setting Name:
Restoring Explicit
Message Type: Error
Job Result: Failure
Setting Name: Restoring
Implicit
Missing (database selected
for backup no longer exists)
Error Message Posted
Job Result: Failure
Setting Name:
Restoring Explicit
Message Type: n/a
Job Result: n/a
Setting Name: n/a
Inaccessible (specified user
cannot access database for
some other reason)
Message Type: Error
Job Result: Failure
Setting Name:
Inaccessible Explicit
Message Type: Error
Job Result: Failure
Setting Name:
Inaccessible Implicit
Note
: SQL 2005 Point-In-Time Snapshots are strictly ignored.
To change behavior:
1.
In the Registry Editor, find the Registry Key
"HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserve
Backup\SQLPAAdp\Common"
2.
Add a new Key within "Common" called "Responses".
3.
Add new DWORD using the setting names shown in the table and set the
values as follows:
0 = Use Agent's default behavior
1 = Warning message posted. Job result is set to Successful
2 = Error message posted. Job result is set to Failure.
3 = Warning message posted. Job result is set to Incomplete.
4 = Error message posted. Job result is set to Incomplete.
Note:
Removing a value entry is the same as setting a value to 0.
