HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SQL Server Full-text crawl log location

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
crawlfulllogsqltextserverlocation

Problem

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.

Solution

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.

Code Snippets

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

Context

StackExchange Database Administrators Q#146777, answer score: 6

Revisions (0)

No revisions yet.