How to: Rebuild All Full-Text Catalogs of a Database (SQL Server Management Studio)

New: 12 December 2006

This topic shows how to rebuild all of the full-text catalogs of a database by using SQL Server Management Studio.


For information about how to rebuild a specific catalog, see How to: Rebuild a Full-Text Catalog (SQL Server Management Studio).

To rebuild the full-text catalogs of a database

  1. In Object Explorer, expand the server group, expand Databases, and then expand the database that contains the full-text catalogs that you want to rebuild.

  2. Expand Storage, and then right-click Full Text Catalogs.

  3. Select Rebuild All.

  4. To the question Do you want to delete all full-text catalogs and rebuild them?, select OK.

  5. In the Rebuild All Full-Text Catalogs dialog box, select Close.

See Also


Full-Text Search How-to Topics

Help and Information

Getting SQL Server 2005 Assistance