Two things, first the short part; We've also got SQL alerts setup in addition to SCOM alerts in case anything on our SQL cluster goes strange. Second, running the...

We've setup our maintenance plans to check the integrity of the databases every night. Plus we've got SCOM in place to alert us of any future failed backups and...

We have regular backups but we aren't sure for how long this problem existed as this is an inherited problem. The powers that be are okay with losing one...

Understood, I'll forgo the repair_rebuild and just do the repair_allow_data_loss. Thanks for the heads up.

I'll probably end up running DBCC checkDB restore_rebuild first to see what happens but I'll have to wait until the weekend to put the DB in single user mode. ...

Keep me posted, I'm definitely interested in the response.

Let's suppose the command returns 0! What's the next step if the rebuild of the index in the maintenance plan is unsuccessful?