136 Agent for Microsoft SQL Server Guide
N
No Icon in Browse Tree • 91
O
ODBC settings, checking and changing • 104
Online Backup of SAP R/3 Databases • 17
Other Options • 31, 38
P
Partial Backups • 17, 114, 122
Partial Restore Dependency Checklist • 128
Partitioning • 112
password changes • 57, 60, 77, 80
Perform an Offline Torn Page Restore Using
Microsoft SQL Server 2005 or 2008 • 68
Perform an Online Torn Page Restore Using
Microsoft SQL Server 2005 or 2008
Enterprise, Data Center, or Developer
Editions • 70
Perform Disaster Recovery in Microsoft SQL
Server 2000, 2005, or 2008 Cluster
Environments • 83
Performance Improvement Tips • 111
post-installation procedures
configuring backup and restore pa • 26
installing • 25
Post-Installation Procedures • 25
Potential Restore Problems • 99
preserving replication settings • 63
R
Recovery Completion State Options • 46, 51
Recovery Models • 113
reinitializing unused pages, in reloading • 123
remote Microsoft SQL server backup • 42
Remote Protocol option • 42
remote Windows database servers, accessing •
15
replication
preserving settings • 63
Replication of Microsoft SQL Server • 95
Required Full Backup • 116, 119, 120
restore
automatic selection • 47
automatic selection • 47
automatic selection option • 47
automatic selection, automatic selection • 47
avoiding problems • 99
by session using separate restore job for
each session • 65
by session using single restore job for each
session • 64
by tree using a separate restore job for each
session • 66
change password • 57
configuring parameters • 26
destination database, requirements • 123
display backup sessions of selected database
• 63
failure during • 123
Keep Replication Settings option • 54
Log Point in Time option • 50
master database • 131
options • 46
overview • 123
reinitializing unused pages • 123
restore by session • 124
restore by session in Microsoft SQL Virtual
Server 200 • 80
restore by tree • 124
restore by tree in a Microsoft SQL Virtual
Server 2000 • 77
Restore Database Files As option • 54
Restore files to their original locations option
• 57, 60, 77, 80
Restricted User Access After Restore option •
54
security • 57, 60, 77, 80
SQL Agent Filter option • 63
to alternate disk location • 63
types • 47
types of backup sessions • 124
uncommitted transactions • 123
using restore by session • 60
using restore by tree • 57, 66, 77
Version History dialog • 57
restore by session
explanation • 124
procedure • 60
Restore by Session in Microsoft SQL Server
2000, 2005 or 2008 Environments • 80
Restore by Session Using a Separate Job for
Each Session • 64, 65
Restore by Session Using a Single Restore Job •
64
restore by tree • 124
explanation • 124
