Full Text Search is not online….

• Close all users out of SME.
• Go Start> Run> type fsmgmt.msc and check for users logged into SME.
• Open MS SQL Studio Manager.
• Go to the Database> <YourDatabaseName> Properties> Uncheck ‘Use full-text indexing’ – click ‘Ok’.
• Right Click on the Database> from the context menu select Tasks> Detach.
• Check the Drop> and Uncheck ‘Keep Full Text Catalogs’ in the databases to detach.

• Click Ok.
• You may/will get an error:

• Doesn’t always pop up.
• Browse to your data folder and make a copy of your database name.mdf & name_log.ldf in a backup folder.
• Delete the Data.ini file as this will force a re-index at startup of SME.
• In Studio Manager – re-attach the database.
• Right click on the Databases> Attach and re-attach the database you just dropped.
• Right Click on the database and select properties:
• Click on the Files in the Select  page and re-check ‘Use full-text indexing’.

• Click Ok.
• Launch SME and answer yes to the re-index prompt.
• Click Yes to Rebuild SME.
• Click No to back up – will not back up without FTS installed.
• Full Text Search should be working correctly after these steps.
• You will need to repeat these steps for each database if you have multiple databases.

Common Error messages:
The backup of full-text catalog 'FTS<your database>' is not permitted because it is not online.
4200023013[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.