CODEWITHSUNDEEP
sql-serverfull-text-search
Newfave
Newfave

Reputation: 186

Gotchas with SQL Server Full-Text Search

I want to compile a list of gotchas when using SQL Server full-text search in all versions.

For instance, Here's a SQL Server Full-Text gotcha:

SQL Server 2008 R2 has a new feature called Data-Tier Applications - which is a way to package a database schema meant to be deployed elsewhere. Certain objects like Full-Text Catalogs can't be packaged and must first be remove before a "DAC Pack" can be created. So you can't create a DAC Pack when there's a Full-Text Catalog in the database.

Can anyone else think of any other SQL Server Full-Text gotchas? Thanks.

Upvotes: 4

Views: 333

Answers (1)

Jonathan Kehayias
Jonathan Kehayias

Reputation: 3412

If you detach a database with a full text catalog, the catalog is not a part of the normal database files, it has its own storage in a folder that has to be copied with the database mdf, ldf, and ndf files. I've seen this be a problem for some people but it is recoverable.

Upvotes: 2

Related Questions