Highlighted

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!!

Scott D Hastings Sr
1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Re: SQL Query for Orphaned Indexes

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.

 

 

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post

9 Replies
Highlighted

Re: SQL Query for Orphaned Indexes

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

For the best O365 Reporting Solution click here Radar-Reporting
Highlighted

Re: SQL Query for Orphaned Indexes

Wouldnt they just show up as null values?
Highlighted

Re: SQL Query for Orphaned Indexes

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

For the best O365 Reporting Solution click here Radar-Reporting
Highlighted

Re: SQL Query for Orphaned Indexes

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

Highlighted

Re: SQL Query for Orphaned Indexes

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. 

Scott D Hastings Sr

Thanks for that Scott, so are

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.  Smiley Happy

For the best O365 Reporting Solution click here Radar-Reporting
Highlighted

Tony, I think it's in the

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...

Scott D Hastings Sr
Highlighted
Accepted Solution!

Re: SQL Query for Orphaned Indexes

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.

 

 

For the best O365 Reporting Solution click here Radar-Reporting

View solution in original post

Highlighted

Re: SQL Query for Orphaned Indexes

Makes perfect sense Tony......

Scott D Hastings Sr