peter.daniels@ihs.com wrote:
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
> (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> I have a database with one data file, one log file and 2 bogus, offline
> FT "files":
>
> FileGroupName FileGroupType FileType FileState
> PRIMARY ROWS_FILEGROUP FULLTEXT OFFLINE
> PRIMARY ROWS_FILEGROUP FULLTEXT OFFLINE
>
> The physical path for both FT folders is not valid. The DB is at now
> at compatibility level 90, but it was at 80. When I try to do an alter
> database remove/modify, I get an error:
>
> "Msg 5009, Level 16, State 9, Line 1
> One or more files listed in the statement could not be found or could
> not be initialized."
>
> How do i get rid of these bogus DB "files"?
>
> TIA,
>
> -Peter