One of the index is in rebuild pending status, now whenever I run the job to rebuild the index, it spits out a lot of message e.g. duplicate keys etc. but does not reset the status i.e. it remains rebuild pending. I tried running CHECK INDEX job but it's telling me that can't access the index as it's in REBUILD PENDING. I don't have a copy of it so can't recover!!! any idea what's the best way to go about doing this.