Sample Header Ad - 728x90

Disable full-text logging (SQL Server)

8 votes
1 answer
889 views
Any way to disable FT logs completely? I spent hours googling - no luck. I get tons of "informational" messages literally *every second*. 2020-01-01 10:43:16.48 spid33s Informational: Full-text Auto population initialized for table or indexed view xxx 2020-01-01 10:43:23.48 spid34s Informational: Full-text Auto population completed for table or indexed view zzz 2020-01-01 10:43:23.48 spid36s Informational: Full-text Auto population completed for table or indexed view xxx 2020-01-01 10:43:24.64 spid12s Informational: Full-text Auto population initialized for table or indexed view xxx 2020-01-01 10:43:25.64 spid12s Informational: Full-text Auto population completed for table or indexed view xxx 2020-01-01 10:43:26.58 spid36s Informational: Full-text Auto population initialized for table or indexed view xxx 2020-01-01 10:43:26.98 spid17s Informational: Full-text Auto population initialized for table or indexed view xxx P.S. My cloud hosting provider charges me for "i/o ops per second" so this is something I want disabled. Also, these logs grow really fast, several gigabytes every week, so I had to write a log maintenance script (rollover + archive etc.)
Asked by jitbit (765 rep)
Jan 2, 2020, 08:39 PM
Last activity: Mar 16, 2024, 02:49 PM