Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I try to attach a database in SQL Server Management Studio 2008 (SSMS), I get prompted by this message:

If you are certain that you have added all the 
necessary full-text catalogs, click OK.

Why is this coming up. It didn't use to.

We did make some schema changes but have done nothing with full-text catalogs.

Is there a way to prevent this coming up?

share|improve this question
Are you attaching a pre-2008 database with FT enabled onto SQL Server 2008? You will need to attach FT catalogs which were separately backed up. From 2008 onwards, the FT catalogs are part of the database itself. If you don't attach the necessary catalogs, you will have to recreate the full text indexes to rebuild the catalogs. – 孔夫子 Oct 8 '12 at 0:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.