Full text index removal

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
You need to disable full-text indexing and then remove the
sysft_phraseologyindex file.
"iiman" <nospam@.nospam.com> wrote in message
news:evP$tdahHHA.1220@.TK2MSFTNGP03.phx.gbl...
> 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
>
>
|||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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e$8GzmhhHHA.4596@.TK2MSFTNGP05.phx.gbl...
> You need to disable full-text indexing and then remove the
> sysft_phraseologyindex file.
> "iiman" <nospam@.nospam.com> wrote in message
> news:evP$tdahHHA.1220@.TK2MSFTNGP03.phx.gbl...
>