fulltext logs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martijn Smilde - 30 Aug 2007 14:31 GMT

Hi,

I have a problem with the FullText logfiles. I have 1 file
(SQLFT0001500005.LOG) which is 1.2Gb. I want to delete (or at least shrink)
this file, and move it to another diskdrive but I don't know how to...

Regards,
Martijn

Reply to this Message

Hilary Cotter - 31 Aug 2007 00:27 GMT

Stop msftesql and then delete it - do this in a batch file as MSFTESQL
automatically restarts itself.. The fact that this file is so large implies
that there are a lot of errors being written to it.

Signature

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

> Hi,
>
[quoted text clipped - 5 lines]
> Regards,
> Martijn

Reply to this Message

Martijn Smilde - 31 Aug 2007 12:48 GMT

Thanx.

Martijn

> Stop msftesql and then delete it - do this in a batch file as MSFTESQL
> automatically restarts itself.. The fact that this file is so large
[quoted text clipped - 9 lines]
>> Regards,
>> Martijn

Reply to this Message