Contents 9
Configure Agent Behavior for Databases Ineligible for Backup
...................................
96
Additional Database Status Considerations
.................................................
98
Microsoft SQL Server Disaster Recovery
........................................................
98
The Master Database
......................................................................
98
Disaster Recovery Scenario
...............................................................
100
Appendix B: Configuring Microsoft SQL Server Security Settings
101
Types of Microsoft SQL Server Authentication
.................................................
101
Authentication Requirements
.................................................................
101
How User Authentication Is Changed
..........................................................
102
Check or Change the Microsoft SQL Server Authentication Method
..........................
102
Update the Agent Account Configuration
..................................................
103
Check and Change the ODBC Settings
.....................................................
104
Update the Backup Manager
..............................................................
105
Appendix C: Backup and Recovery Best Practices
107
Microsoft SQL Server Database Basics
........................................................
108
About Files and FileGroups
...............................................................
108
Performance Improvement Tips
...........................................................
111
Recovery Models
.........................................................................
113
System Databases
.......................................................................
114
Backup and Restore Considerations in Microsoft SQL Server Cluster Environments
...........
115
Backup Concepts
............................................................................
115
Backup Considerations
...................................................................
116
Restore Overview
............................................................................
123
Restore Types and Methods
..............................................................
124
Checklists for Dependencies, by Type
.....................................................
125
Microsoft SQL Server Disaster Recovery Elements
..........................................
131
Restore Master Databases
................................................................
132
Index
133