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.