Full text index removal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

iiman - 23 Apr 2007 14:00 GMT

RESTORE FILELISTONLY
FROM DISK = 'C:\Full0100.BAK'

Here is the result

database d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\database
.mdf
database _Log d:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\database _log.ldf
sysft_PhraseologyIndex d:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\FTData\PhraseologyIndex

I would like to remove the sysft_PhraseologyIndex. The database server does
not have full-text component installed (this particular database was created
with sql server 2000 that supported the full-text indexing and upgraded to
sql server 2005 that does not support full-text index)

Thanks

Reply to this Message

Hilary Cotter - 24 Apr 2007 02:14 GMT

You need to disable full-text indexing and then remove the
sysft_phraseologyindex file.

> RESTORE FILELISTONLY
> FROM DISK = 'C:\Full0100.BAK'
[quoted text clipped - 16 lines]
>
> Thanks

Reply to this Message

iiman - 24 Apr 2007 14:29 GMT

I tried,

ALTER DATABASE scope
REMOVE FILE sysft_PhraseologyIndex

I get

Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.

How do I remove the file?

Thanks

> You need to disable full-text indexing and then remove the
> sysft_phraseologyindex file.
[quoted text clipped - 21 lines]
>>
>> Thanks

Reply to this Message