June 24, 2013 at 7:25 am
I have an Index Rebuild that has been failing. It fails on the same table/index everytime. Looking at this history of the index job, I see entries like this, "Rebuild - [PK_CCX] [SQLSTATE 01000] (Message 0)" and then the very last entry is, "Rebuild - [PK_CCW_TOX] [SQLSTAT... The step failed." I am needing to find more information on this failure. I have checked the SQL Agent Error Logs and there is not a whole lot there, as in maybe 25 entries total. I then try the SQL Server Error Logs and search for the index and nothing comes back.
I have queried the table to see if there is some data out of place for these two columns that make up the PK and everything seems correct. To add to this, the table is not very big (almost makes me wonder why it needs to be rebuild, but I can worry about that once I get this corrected).
Can anyone point me in the right direction on where I can look to get more information on why this Index Rebuild is failing?
Any and all advice on this subject will be greatly appreciated...Thank You.
June 24, 2013 at 7:54 am
I suggest to run the index rebuild in ssms and see what the error you will get.
June 28, 2013 at 10:35 am
I agree, do the rebuild in management studio and see what happens.
If still no usable result use the CHECKTABLE statement (have a look at books online). It's similar to CHECKDB but for a specific table only. Maybe you get something.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply