Full-Text Search Catalogs
With SQL Server 2005, Microsoft added full-text search enhancements that let you back up and restore one or more full-text catalogs. You can now backup catalogs with, or separate from, your database data.
A database can hold one or many full-text catalogs, but a catalog can only belong to one database. A full-text catalog holds the full-text indexes created for one or more tables, but a table can have only one full-text index.
Full-text catalogs are not stored in regular data files, but are still treated as files in the database are therefore included in the database file set you can back up. You can perform a complete (full) or a differential backup and restore of a full-text catalog. An individual full-text index created for a particular table can be assigned to a FileGroup and then backed up or restored as usual.
|
Copyright © 2016
|
|