In
SQL Server 2005, full-text catalogues are backed up automatically whenever a full or filegroup
backup occurs (given that the catalogues are associated with the filegroup being
backed up). It can be convenient to have those catalogues included automatically, but
they can increase the size of the full or filegroup backup significantly. If your database
makes use of full-text search, be sure to keep this fact in mind.
I??™ll cover filegroup backups and how they relate to full-text search in detail in
Chapter 4.
CHAPTER 2 n MAKING DATABASE BACKUPS 37
Backup and Disaster Categories
So how do recovery modes, recovery locations, and individual backup options apply to
the disaster criteria I??™ve already established? How do they help or hinder in mitigating the
impact of the disaster?
Recovery Modes
Failure can occur in a number of different categories. Your choice of recovery mode
affects the ease with which you can recover from a problem within each category:
??? Environmental: The recovery mode doesn??™t matter for this category. A tornado
doesn??™t care if your database is in Simple Recovery or Full Recovery mode.
Pages:
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114