Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2008-09-19 : 09:31:41
|
Hi All, I have a little issue with Full Text Searching on a SQL Server 2000 Enterprise SP4 Cluster . . . . Surprised . . . No I thought not :)It has only come to light when I moved a database from another server This databases had a FulltextCatalog that the developers neglected to mention . . . . I know I should have checked it all Doh!Initially the Catalogue was on a disk that didn't exist on the new server . . . no problem, I'll delete them and recreate them . .. No I won't The Full Text Service Failed, causing the Cluster to failover as well, then it failed back because it failed to start on the other node, and spent about 10 minutes bouncing between the nodes, until I got in and stopped the Full text Resource from restarting automatically. fall back to last ditch plan, and enabled direct updating of the system catalogs - edit the path tot he catalog for the database directly . . . Then disbale direct updating.Brought full text back on line . . . . Cluster stayed stable . . . .Yay! . . . I say Yay! Now tried to drop the catalog . . . failed cause I can't administer Full text under my (sysadmin) account . . . Huh? well much googling and scratching of heads later realised that as usual I have disabled BUILTIN\Administrators . .Change MSSearch Service to run as A service Account and added Service acount to SQL logins on server . . . . I can now administer Full text . . . Yay! . . . But . . . (What You didn't expect a But?) . . . any thing I try (like rebuilding the catlogs) comes up with a "Error 7619: Execution of full-text operation faled. A parameter is incorrect". . . . Ok Back to Google, and I found a couple of things but still, am getting the same thing.Also SQL Server Full Text Search Resource in Cluster Admin Shows as Offline . . . in Enterprise Manager / Management Studio it is apparently online . . . .I'm thinking that the registry is somehow corrupt for full text search . . . Any way I can do a manual reinstall of Full text . I really don't want to go down the route of reinstalling SQL Server, If I can at all help it. -- RegardsTony The DBA |
|
|
|
|
|
Full Text is 'Broken'