To help you successfully master the exam objectives presented in this chapter, complete the following tasks.
Check the FTS Dynamic Management Views and Backup and Restore of a Full-Text Catalog and Indexes
There is also some administrative work involved with full-text indexes. For a brief introduction to this administrative work, you should review the information provided by the dynamic management views that deal with full-text search and semantic search, and learn how to back up full-text catalogs and full-text indexes.
Practice 1 In order to understand full-text search thoroughly, check the information provided in the following dynamic management views:
Practice 2 Backup and restore is a very typical DBA job. You should have basic knowledge of how to include full-text catalogs and indexes in a backup. See the Books Online for SQL Server 2012 article “Back Up and Restore Full-Text Catalogs and Indexes” at http://msdn.microsoft.com/en-us/library/ms142511.aspx to study how to perform the following tasks:
Finding the full-text indexes of a full-text catalog
Finding the file group or file that contains a full-text index
Backing up the file groups that contain full-text indexes