Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In Microsoft SQL Server 2005, full-text catalogs can be attached and detached together with the database. This is possible because the ATTACH operations of the CREATE DATABASE statement have been enhanced so that full-text catalog files are treated like database files. So, when you attach a database that contains full-text catalog files, SQL Server attaches them from their previous location along with the other database files. The state of the full-text catalog before the database was detached is carried forward to the new location. Also, SQL Server resumes any full-text index population that was suspended during the detach operation and the full-text index is available for full-text search.
If SQL Server cannot find the full-text catalog file, or the full-text file is moved but the new location is not specified, the full-text catalog will be offline and you must rebuild the offline full-text catalog before using Full-Text Search.
See Also
Other Resources
Detaching and Attaching Databases
CREATE DATABASE (Transact-SQL)
sp_detach_db (Transact-SQL)