HI THERE,
I have a full text catalog that is created on the D: drive of a server. The catalog is created with the following syntax:
CREATE FULLTEXT CATALOG [fti]
IN PATH N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData'
WITH ACCENT_SENSITIVITY = OFF
AUTHORIZATION [dbo]
The properties are that the last population date was in 11/10/2008 and tyhe track changes is set to automatic.
The problem is the .ci files are consuming half of the 10GB available on the drive.
Is there any maintenance plan i can create that can shrink/remove the older files?
I have a full text catalog that is created on the D: drive of a server. The catalog is created with the following syntax:
CREATE FULLTEXT CATALOG [fti]
IN PATH N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData'
WITH ACCENT_SENSITIVITY = OFF
AUTHORIZATION [dbo]
The properties are that the last population date was in 11/10/2008 and tyhe track changes is set to automatic.
The problem is the .ci files are consuming half of the 10GB available on the drive.
Is there any maintenance plan i can create that can shrink/remove the older files?