fulltext logical files offline and can't be deleted



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

.



Relevant Pages

  • Re: Capitalise words?
    ... > If a user wants to put a bogus name, ... > maintaining this database, requires some help from the system it's self. ... I know that Jannie Van ... if you capitalize the words then ...
    (alt.php)
  • Re: DataReader Seek
    ... I just emailed you a sample CF app (CAB and source) that loads your database with bogus item data and ...
    (microsoft.public.sqlserver.ce)
  • Strange Problem With Form
    ... mde without giving any problems. ... after I save the form and try to reopen it I get a bogus "out of ... memory error) and still won't open in either view if imported into a ... clean database. ...
    (comp.databases.ms-access)
  • Relationship tables auto-created?!?
    ... I'm designing an Access 2000 database. ... Access has automagically created some bogus tables in the relationship ... talking about automatic creation of relationship tables either. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Upload Problem Using ASP
    ... administration form offline to the offline database, ... certain field i made in database. ... I can read images names by the same way, do u have anyway to complete ... > make a small visual basic program to upload the database and the images to ...
    (microsoft.public.inetserver.asp.general)