- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
- Agresso AskSSC Assyst Axios Azure Backup Book Review Books Career Certification Cluster Configuration CSV CTE DBCC Denali Deployment Design Disaster Recovery Documentation Education Error Message ETL Execution Plans Full Text Indexes Indexing Installation IT Management Kaseya Kindle Maintenance Maintenance Plans Management Meme Monday Memory Migration Misconceptions Monitoring MSDB Myths Normalization People Performance PowerShell Programming red-gate Restore SQL Agent SQLBits SQL Monitor SQLPrompt SQLSaturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQLSouthWest SSMS ssmstoolspack SSRS T-SQL T-SQL Tuesday Tools Training Troubleshooting Un-SQL Friday Upgrade User Group Virtual Machines Windows 2012 WordPress WTF XML
Tag Archives: Full Text Indexes
Database Migration / Upgrade problem – Fulltext Wordbreaker, filter, or protocol handler does not exist
Long title. Sorry about that. What? I was migrating a few databases to a slightly upgraded server – new hardware, same OS/SQL main version, but the new one was fully service packed / updated etc. The environment dictated that I … Continue reading →
Here’s a little bit of the pain that I’m facing today. I was trying a SQL Server RESTORE (using Quest’s Litespeed for SQL Server) of one of our databases, one that has a fulltext index. The restore was consistently failing … Continue reading →
While monitoring database restores in the DR environment, as you should do, I noticed the following warning message: Warning: Wordbreaker, filter, or protocol handler used by catalog ‘foo_FullText’ does not exist on this instance. Use sp_help_fulltext_catalog_components and sp_help_fulltext_system_components check for … Continue reading →