October 29, 2001 at 3:25 pm
I am running SQL 7.0 and have recently started experiencing problems with Full Text Catalogs getting lost after I reboot the server. This has happened the last 3xs I've rebooted the server. I can see the physical fold and files in their proper directory and it doesn't look like any of their file names have changed, but when I view them from inside E.M. they show zero bites for each one. I have to rebuild the catalogs, then repopulate them. Since I have about 10 catalogs and a couple of them are about 1.5 million records then this process takes about 1 1/2 to 2 days. Can someone please shed some light as to why these are getting lost after a reboot and what I can do to prevent this from happening?
Thanks!
Jeff Matthews
Jeff Matthews
October 30, 2001 at 5:57 am
No idea. I've only got SQL2K installed, I emailed Jon Winer to see if he had any ideas, he has done quite a bit of work with FTS. Are you getting error messages, either in SQL or the event log? Had you made any other changes to machine prior to this problem starting?
Andy
October 30, 2001 at 6:24 pm
Jeff,
I have run into this same problem in the past. I don't remember finding a fix for it, except that when I upgraded to SQL 2000, the issue went away.
What else do you have running on the machine...IIS?
Give me a day or so...I'll take a look around to see if I can find some answers for you. Thanks.
October 30, 2001 at 6:44 pm
I vaguely remember something about passwords or users and full text cats but I think that was just the population failing. If you have changed any users/passwords that may be connected with this it might be worth setting them back to the original values and trying it.
Cursors never.
DTS - only when needed and never to control.
October 31, 2001 at 6:23 pm
In speaking with a contact at Microsoft, it looks as though it is a known issue. Do you have SQL2000 to upgrade to?
October 31, 2001 at 7:29 pm
Do you know the conditions under which it happens?
I left a client with a full text cat solution and would like to warn him about this.
Cursors never.
DTS - only when needed and never to control.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply