Forum Discussion

Scott__Hastings's avatar
9 years ago

SQL Query for Orphaned Indexes

I'm sure this can be done, but my brain isn't big enough.

We have some old indexes that don't seem to be associated with an archive. Can someone help me with a query to to identify "orphaned index folders/volumes?

 

 

Thanks!!

  • If someone made copies of an index then there is an original that is accounted for in the db.  EV won't know about the copy.

     

     

9 Replies

  • If the indexes are not associated with an archive I do not think they would be in SQL.

  • What would be NULL?  If the archive is deleted what are you going to link on?

  • why are you trying to solve this with sql instead of the index management tools themselves?

  • Andrew, I just thinkSQL would be much faster. Tony, the archive hasn't been deleted, I just think someone made copies of Indexes that are no longer associated with archives. 

  • Thanks for that Scott, so are you wanting to match them by location?  If they are in the same location you could check the Index Volume Path to see if that location is in the EV db.

    End of the day, if you think they are copies just taking up space you could delete them.  If they are needed they will be rebuilt.  What is the scale of the issue?  Is it just a few?  If it is hundreds just deleting may require some more indepth investigation to be positive they are copies rather than just nuking them.  :)

  • Tony, I think it's in the 100's, so I need to do some indeth investivation. 

     

    I suppose I was if the same mind as Jimmy.... that orphaned indexes would return NULL as an archive...

  • If someone made copies of an index then there is an original that is accounted for in the db.  EV won't know about the copy.