By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,912 Members | 1,978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,912 IT Pros & Developers. It's quick & easy.

How could a database spontaneously loose it's indexes?!?!?!?

P: n/a
HELP! I have a rather large - production level database (2 tier -
front end and back end) and it was starting to run slow so we decided
to do a repair and compact on the back end (data). On the repair we
get an error message that the database can't repair because it's
missing some indexes! When I just try to open it I see nothing! I
was able to get it to compact and then I could finally see my tables,
etc... How would a database just spontaneously loose it's indexes?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
the repair and compact copies all the collections to a temporary DB then
renames it. in the copy the indexes didnt make it.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.