Where is the FULLTEXTCATALOGPROPERTY(LogSize) log?   

Where is the log full-text error log
    FULLTEXTCATALOGPROPERTY('MyCatalogName', 'LogSize')
refers to in SQL Server?

"Size, in bytes, of the combined set of error logs associated with a 
Microsoft® Search Service full-text catalog."

File somewhere?
Windows event log?
SQL Server Logs?


Keywords: FULLTEXTCATALOGPROPERTY, LogSize, SQL Server, Full-text, full 
text, fulltext, error log, error-log

date: Thu, 27 Mar 2008 09:59:45 -0400   author:   Ian Boyd

Re: Where is the FULLTEXTCATALOGPROPERTY(LogSize) log?   

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG>

Replace X with your instance number.

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Ian Boyd"  wrote in message 
news:uZ8YRLBkIHA.5556@TK2MSFTNGP05.phx.gbl...
> Where is the log full-text error log
>    FULLTEXTCATALOGPROPERTY('MyCatalogName', 'LogSize')
> refers to in SQL Server?
>
> "Size, in bytes, of the combined set of error logs associated with a 
> Microsoft® Search Service full-text catalog."
>
> File somewhere?
> Windows event log?
> SQL Server Logs?
>
>
> Keywords: FULLTEXTCATALOGPROPERTY, LogSize, SQL Server, Full-text, full 
> text, fulltext, error log, error-log
>

date: Thu, 27 Mar 2008 11:28:26 -0400   author:   Hilary Cotter

Re: Where is the FULLTEXTCATALOGPROPERTY(LogSize) log?   

"Hilary Cotter"  wrote in message 
news:u0QL28BkIHA.2396@TK2MSFTNGP05.phx.gbl...
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG>

There are files
    ERRORLOG
    ERRORLOG.1
    ...
    ERRORLOG.6

and
    SQLAGENT.1
    SQLAGENT.2
    ...
    SQLAGENT.9
    SQLAGENT.OUT

and .txt files that seem to be for the database maintenance plans:
    Avatar Databases4_200803262101.txt
    Avatar Databases4_200803252100.txt
    Avatar Databases0_200803230101.txt
    etc.

i assume the full-text entries are contain in ERROR.* files, and that the 
log is not exlusivly used for logging full-text errors? These files appear 
identical to what's available in Management -> SQL Server Logs -> Current. 
Are the full-text error entries contained in these files? Searching the 
files i don't see the words "full-text", "full text", "fulltext", "full", or 
"text"

Looking in this file it has a "Source" column, which contains values:
    backup
    server
    spid3
    spid5
    spid10
    spid11
    spid52
    spid54
    ...
    etc


Supposedly there are log entries somewhere:

SELECT FULLTEXTCATALOGPROPERTY('FrontlineFTCatalog', 'LogSize') AS 
LogSizeInBytes

LogSizeInBytes
-------------- 
4643

(1 row(s) affected)


So i have 4k of error logs somewhere.

date: Thu, 27 Mar 2008 13:34:40 -0400   author:   Ian Boyd