Corrupt index after removing a server from monitoring?

Mlanahan

Unable to find index entry in index ID 1, of table 1202103323, in database 'RedGateMon..'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.

 after running a dbcc 1202103323 is Cluster_SqlServer_Database_File_Sightings.  Is it okay to drop and Recreate this clustered index while the monitor is running?  My gut says its probably fine, but just want to make sure.  Thanks.

 

Mlanahan

To address the title, I started getting this error after I removed a test server from our monitoring.  Thanks.

squigley

Good Afternoon!

Thanks for your inquiry with SQL Monitor.

I believe doing a rebuild should work, but I want to double check first before suggesting it.
I'll update you once I know more.

squigley

Good Morning!

I was able to get the following recommendations.

You should first run DBCC CHECKTABLE to figure out if it's even recoverable.
While that's running, you should also look in the Windows Event Viewer to determine if your storage is failing.

Can you let me know of your results for the above?

Thanks!