How can we help you today? How can we help you today?

Corrupt index after removing a server from monitoring?

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
0

Comments

3 comments

Sort by
  • Mlanahan
    To address the title, I started getting this error after I removed a test server from our monitoring.  Thanks.
    Mlanahan
    0
  • 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
    0
  • 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!

    squigley
    0

Add comment

Please sign in to leave a comment.