This might be a silly question, but I can't for the life of me figure out where the crawl logs for my SQL Server 2012 instance are. TechNet says to look under %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG for 2008, but the LOG folder does not exist under %ProgramFiles%\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL.

I have upwards of 500,000 failed records after my last FTS index population and I need to know what the issue is.


You should be able to find the full text log location with the following code:

xp_readerrorlog 0, 1, N'Logging SQL Server messages in file'

I don't think it's possible to split them away from the normal SQL Error log as this connect suggests.

| improve this answer | |
  • Thank you! That provided the location. IT/DBA seems to have moved the logs folder to the D: on that machine. – hsimah Aug 15 '16 at 1:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.