SQLTeam.com | Weblogs | Forums

Sql database corruption

sql2014

#1

Hi all,

I m using SQL Server 2014, I go next xxxx.mdf file during couple months. And yesterday evening I found out that: "Corruption on non-clustered indexes"

Such error message shows me SQL Server.

I dont know what to do with such issue.

If anyone proper decision, please share with me.


#2

Can you post the error?


#3

Check the disk subsystem, because your controller or hard drives may be having errors. Otherwise you shouldn't get that much SQL corruption in so short a time.

Since they are nonclustered indexes, you can simply drop and recreate them. Don't try that with a clustered index!, since the clus index is the table itself.


#4

May be you are running a complicated UPDATE statement with a NOLOCK hint against a table in SQL Server. See here for more detail https://support.microsoft.com/en-us/kb/2931693 or you can restore to the last known good backup.


#6