I have had this database running for about 3 years now and for the past few months I keep getting tables that are crashing. They appear to be the same tables each time. What are some causes for this to happen? I have checked the server and it has not been shutting down or restarting other than when I install updates and restart it myself. That has yet to cause a problem.
At first this happened just once and awhile but now it seems to happen every week. I have not been able to pinpoint anything going on when this happens. Any ideas on what to look for would be greatlly appreciated.
I have this running on a windows server 2003 box using apache server.
Also, if you know of any way I can use a script to check the database and fix it automatically that would be great since I am not always able to check on the database on the weekends.