When you back up
that filegroup, the files associated with the full-text indexes are included.
Figure 4-9. When creating a full-text catalog, you must assign it to a filegroup, even though
the indexes themselves are stored externally.
Technically, all of the full-text indexes are files contained outside of the database. To
back up a full-text catalog in SQL Server 2000 and earlier, you had to stop the Microsoft
Search service (which technically implements full-text searching), back up the files in the
full-text directory, and restart Microsoft Search. Even so, if you didn??™t back up the database
at the exact same time, the search may not have restored properly anyway.
CHAPTER 4 n BACKING UP AND RESTORING FILES AND FILEGROUPS 95
Normally in the event of a failure, you would just repopulate full-text indexes from
scratch. For many, that isn??™t a problem. I did, however, have one instance of a complete
database failure. The restore of the database took only 90 minutes, but rebuilding the
full-text catalog took almost ten hours. It turned out that the application depended
almost entirely on full-text search, and I had to rebuild numerous indexes.
Pages:
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204