fulltext logical files offline and can't be deleted
- From: peter.daniels@xxxxxxx
- Date: 7 Dec 2006 15:04:29 -0800
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
.
- Follow-Ups:
- Re: fulltext logical files offline and can't be deleted
- From: peter . daniels
- Re: fulltext logical files offline and can't be deleted
- Prev by Date: Union with duplicated records
- Next by Date: Re: Union with duplicated records
- Previous by thread: Union with duplicated records
- Next by thread: Re: fulltext logical files offline and can't be deleted
- Index(es):
Relevant Pages
|