Querying Full-Text Data in Microsoft SQL Server 2012
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