SQL Server Corrupt Index

[aidanopieri]

We had a corrupted index last night, I'm wondering if there is appropriate regular maintenance that we should do to prevent this again? I saw something about rebuilding indexes on a regular schedule? Is this true?

What could cause a corrupted index?
Thanks!!

 

[philhege]

To your last question, a lot:

https://www.google.com/?gws_rd=ssl#q=sql+server+index+corruption+causes

Are you rebuilding online? There's potential for contention. You should apply a rule of thumb to the reindex/rebuild question. I've seen a threshold of around 30% fragmentation to trigger a rebuild decision, but YMMV.

-----------
With business clients like mine, you'd be better off herding cats.