Querying Full-Text Data in Microsoft SQL Server 2012

Suggested Practices

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:

  • sys.dm_fts_active_catalogs

  • sys.dm_fts_fdhosts

  • sys.dm_fts_index_keywords_by_document

  • sys.dm_fts_index_keywords_by_property

  • sys.dm_fts_index_keywords

  • sys.dm_fts_index_population

  • sys.dm_fts_memory_buffers

  • sys.dm_fts_memory_pools

  • sys.dm_fts_outstanding_batches

  • sys.dm_fts_parser

  • sys.dm_fts_population_ranges

  • sys.dm_fts_semantic_similarity_population

• 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