03-13-2016 12:28 PM
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!!
Solved! Go to Solution.
03-14-2016 07:44 PM
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.
03-13-2016 06:19 PM
If the indexes are not associated with an archive I do not think they would be in SQL.
03-13-2016 06:47 PM
03-13-2016 07:22 PM
What would be NULL? If the archive is deleted what are you going to link on?
03-13-2016 07:27 PM
why are you trying to solve this with sql instead of the index management tools themselves?
03-13-2016 07:52 PM
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.
03-14-2016 07:08 AM
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. :)
03-14-2016 12:11 PM
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...
03-14-2016 07:44 PM
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.
03-14-2016 08:53 PM
Makes perfect sense Tony......