Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

we are re-loading a db with new data using backup/restore process. Once restore is complete, we re-build the full-text catalog. Full text searches work, no timeouts for about a day or so. However if the search hasn't been used for a day, two days, the searches timeout. If I were to re-build a catalog when timeouts occur, everything works. It also works if a user does any search at least once a day.

I can set to re-populate catalog once a day (early in the morning let's say.) However, is this the right approach? It would cover up the issue, but what's the cause of it? We're using SQL Server 2005 and Win Server 2003 and search is done through web interface.

Thank You.

share|improve this question

migrated from stackoverflow.com Oct 6 '09 at 17:11

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

I had the same issue, and the fix described in this KB article did the trick.

sp_fulltext_service 'verify_signature', 0;
GO

Even though it says this is only a problem for servers not connected to the Internet, we found that it could effect servers with weird Internet connection setups.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.