Error Enabling FullText Search on SQL Database

[kg00se]

I am having problems enabling SQL Full Text Search on a database. when I run the following script on a particular Database: sp_fulltext_database 'enable'

this is the error that I am getting:

(1 row(s) affected)


(0 row(s) affected)

Server: Msg 7619, Level 16, State 2, Procedure sp_fulltext_database, Line 61
The process cannot access the file because it is being used by another process.

I have tried to run the following script to resolve the problem:
sp_fulltext_service 'clean_up'

this shows that it runs fine but still cannot enable the full text search on the database.

any thoughts on how to fix this would be appreciated.

Thanks
kg00se

 

[mrdenny]

Looks like you've got two databases trying to use the same folder for it's full text indexes. Are there full text indexes already created on the database, and your just trying to get it all working again?

Is there another instance with full text indexing enabiled?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog