WinXP, A2K2. 70mb back end on Win2003 Server. About 200 tables. Nightly compact. Discovered a complete loss of all indices. Any tables with indices had the fields indication as an index changed to no. Not entirely sure it was the compact process that caused it, but highly probable. Prior to compact DB was 70mb, after 59mb. Anyone seen this type of problem before? Any advice?
That is a scary thing to hear. I have had no experience with that (thankfully) however I remember responding to a posting within the past week or so with a similar problem. You can go to this thread and see if there are any similarities. http://www.dbforums.com/showthread.php?t=1065381