Index 137
procedure • 57
Restore by Tree in Microsoft SQL Server 2000,
2005 or 2008 Cluster Environments • 77
Restore by Tree Using a Separate Job for Each
Session • 64, 66
Restore Database Files As option • 54
Restore Databases Using Restore by Session
Method • 60
Restore Databases Using Restore by Tree
Method • 57
Restore Files to Their Original Locations option •
57, 60, 77, 80
Restore Master Databases • 98, 131
Restore Options • 46
Restore Overview • 123
Restore to Alternate Disk Locations by
Individual Session • 64
Restore to Alternate Disk Locations Using
Automatic Selection • 63
restore types • 47
Restore Types • 46, 47
Restore Types and Methods • 124
Restoring Microsoft SQL Server Databases • vi,
16, 45
Restricted User Access after Restore option • 54
S
SAP R/3, backing up with SQL Server • 17
scheduling backups • 42, 116
security
information • 57, 60, 77, 80
specifying during restore • 57
Security and Agent Information dialog • 42
Select Backup Destination, Schedule, and
Submit the Job • 76
Select Server, Protocol, Security, and Backup
Type • 74
Skip or Include Database Files in Backups • 89,
116
SQL Agent Filter option • 63
SQL Agent Filter Options • 63
SQL Server DBAgent Configuration dialog • 26
standard Microsoft SQL Server environment,
Account Configuratio • 24
Suggested Database Restore Sequence • 99
system administrator privileges • 101
System Databases • 114
T
The Master Database • 98
Torn Page Repair Dependency Checklist • 129
transaction log
applying • 47
database activity records • 120
loading sequentially • 47
minimizing number of, with differential
backup • 119
restoring • 47
transaction log backup
advantages • 120
defined • 120
full database backup required before • 121
options • 36
run separately • 120
truncate • 121
Transaction Log Backups • 120
Transaction Log Restore Dependency Checklist •
126
Troubleshooting and Disaster Recovery • 85
Truncate Transaction Logs • 16, 120, 121
truncating transaction log backups • 121
types of backups • 36
Types of Microsoft SQL Server Authentication •
101
U
Update the Agent Account Configuration • 88,
103
Update the Backup Manager • 105
Upgrade Considerations for the Agent for
Microsoft SQL • 88
user account specifications • 101
V
version history • 57, 77
