"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
>
>
>
>

"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...
>> 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
>>
>>
>>
>>
>
>