134 Agent for Microsoft SQL Server Guide
Backup or Restore Operation Failed • 91
Backup Overview • 29
Backup Strategy Recommendations • 117
Basic Prerequisites • 21
C
CA ARCserve Backup Agent for Microsoft SQL
Server
error • 85
troubleshooting • 85
CA Product References • iii
Check and Change the ODBC Settings • 104
Check or Change the Microsoft SQL Server
Authentication Method • 102
Checklists for Dependencies, by Type • 125
cluster environment
backup, Microsoft SQL Server 2000 • 74
differences • 73
installing agent on all nodes • 73
restore by session, Microsoft SQL Server 2 •
80
restore by tree, Microsoft SQL Server 2000 •
77
complete backup
defined • 36
restoring • 47
Configure Agent Behavior for Databases
Ineligible for Backup • 96
Configure Backup and Restore Parameters for
the Agent for Microsoft SQL Server • 26
Configuring Microsoft SQL Server Security
Settings • 101
configuring the TCP port address
post • 26
Contact CA • v
Continue Restore After Checksum Failure • 46,
53
CREATE INDEX statement, impact on backups •
122
D
Database
consistency • 117
locking • 123
restoring lost or damaged • 123
database consistency check
defined • 117
options • 117
Database Consistency Check (DBCC) Options •
31, 36, 46, 52
Database Consistency Check option
explained • 36
Database Consistency Checks • 117
Database File Options • 54
Database Mirroring • 112
Database Restore Dependency Checklist • 125
Database Subset • 34
DBCC CHECKCATALOG • 117
DBCC CHECKDB • 117
destination database • 123
differential backup • 119
advantages • 119
defined • 119
file and file group • 36
restoring • 47
supplemental to full backups • 119
type • 36
when to perform • 119
Differential Backup Timing • 119
Differential Backups • 17, 119
Disaster • 83
disaster recovery
in a standard MS SQL Environment • 100
in a standard MS SQL Server Environment •
100
scenario • 100
disaster recovery Microsoft SQL Server • 98
Disaster Recovery Scenario • 100
display backup sessions of selected database •
63
Documentation Changes • vi
dump • 13
Dynamic and Explicit Job Packaging • 38, 42
dynamic job packaging • 38
Dynamic Job Packaging • 39
E
E8535 • 92
error messages • 85
explicit job packaging • 38
Explicit Job Packaging • 40
F
failure during restore • 123
file and file group
backup type • 36
Files and FileGroup Backups • 114, 121
