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?
Solved! Go to Solution.
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...