Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    130

    Unanswered: Unexplained Loss of Indexes

    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?
    thanks,
    Winston

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Winston,

    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

    Good luck. Let us know what you find out.

    TD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •