I have a sql server 2012 block that hosts hundreds of databases. All databases use full-text indexing. Indexing has stopped working.
execution of this request:
SELECT status_description
FROM sys.dm_fts_index_population
returns status_descriptionequal Startingfor all databases where recent activity has been active.
I created a new database and created a full text index. This problem has the same problem, the population is not ending.
What could be the reason? Can I somehow reset to serve the full text index without serving the SQL Server service itself?
source
share