I am trying to find a SQL person to help with a problem.

Somehow, and I am not exactly sure how it happened, the
"sysft_ftcat_documentindex" SQL file for my MSCRM data base got separated
from the other SQL data base and log files and was placed on a separate drive
which failed and had to be replaced. I did not have a backup of that file.

As I was saying, Microsoft CRM works fine but I cannot do a full SQL
database backup because that file does not exist. I can do a partial data
base backup but I would like to do a full data base backup.

Also, everytime the server is rebooted I lose my CRM METABASE data base and
that has to be restored from a backup.

Is there any way through SQL that "sysft_ftcat_documentindex" can be
recreated and if so how?

Thanks.


Rick Bellefond
RB Data Services