patternMinor
SQL Server Full-text crawl log location
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
I have upwards of 500,000 failed records after my last FTS index population and I need to know what the issue is.
%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:
I don't think it's possible to split them away from the normal SQL Error log as this connect suggests.
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.