Help center

View helpful articles, tutorials and FAQs on the set-up and configuration

of the FocalScope omnichannel suite, according to best practice.

How to restore Full-Text Search functionality in FocalScope

FocalScope's search feature relies on the Full-Text Search SQL Server component to be installed and working. If the Full-Text Search component is not installed or has become out of sync with the FocalScope database, FocalScope search will be unable to locate specific text in emails. This article will detail the steps needed to verify if Full-Text Search is installed and how to install / re-synchronize it if necessary.


  • Searches in FocalScope give empty results
  • Searches in FocalScope give results that are mismatched with the specified search criteria
  • You cannot find a message you are sure is in FocalScope


  • The Full-Text Search component is missing or out of sync with the FocalScope database
  • The Full-Text Search service has stopped
  • The Full-Text Search catalogs are not tracking changes or have become damaged, usually do to:
    • Performance problems
    • Maintenance activity on the SQL server
    • Database migration (backup / restore)

Troubleshooting & Resolution

Step 1 - Checking if the Full-Text Search feature is installed

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Installation Center]Please note, if you are prompted to locate the installation media, it may be necessary to download the SQL Server installer from Microsoft -

Figure 1 - Launching SQL Server Installation Center

  • At the opening screen select [Installation] in the left-hand list, and in the right-hand list click [New installation or add features to an existing installation]Please note, it may take a minute for the installation program to prepare itself

Figure 2 - Installing new features to SQL Server

  • When the [SQL Server 2008R2 Setup] screen loads, select the [Add features to an existing instance of SQL server 2008 R2] option
  • Click [Next] to continue

Figure 3 - Specifying your existing SQL instance

  • If the [Full-Text Search] checkbox is grayed out with a check through it, it means Full-Text Search is already installed for the instance (proceed to Step 2 directly). If the checkbox is blank, tick it to elect Full-Text Search for installation
  • Click [Next] and complete the rest of setup process, leaving all parameters at their defaults

Figure 4 - Installing Full-Text Search

Step 2 - Checking that the Full-Text Search service is running

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager]

Figure 5 - Launching the SQL Server Installation Center

  • Note the state of the [SQL Full-text Filter Daemon Launched] service. If the status is Stopped or Paused, right click the service and select [Start] or [Resume]

Figure 6 - Launching SQL Server Installation Center

Step 3 - Rebuilding FocalScope Full-Text Search catalogs

  • In the Windows Start menu, run [Microsoft SQL Server 2008 R2 > SQL Server Management Studio]

Figure 7 - Launching SQL Server Management Studio

  • At the login screen, log into your SQL Server instance. Please note, you in case of a named SQL server instance specify the [Server name] as ServerName\SQLInstanceName

Figure 8 - Logging into your SQL Server instance

  • Expand the [Server Name > Databases > focalscope_emm > Storage > Full Text Catalogs] folder
  • Right click the catalog that you wish to rebuild and select [Rebuild]

Figure 9 - Rebuilding the FocalScope Full-Text Catalogs

Additional Information

Let us help

If you have any questions, or need further support, please don’t hesitate to reach out.