DBCC REINDEX failed with errors

Question

DBCC REINDEX failed with errors

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

I'm not really seeing any error messages in there (or I could be missing something).

If you want to get better output of possible errors, on the job step doing the reindex, edit that step, go to Advanced and in the middle of the screen there is a section for Output File.

Add a filename in a directory that the Agent has permissions for (the built in Jobs directory should work). You can then review the file and get better details of any errors.

Sue

21.naved SSC Eights! Points: 854 More actions · Answer 2

it show only these messages and at the end as step failed....

I ran reindexing for individual db's and found that 2 of the DB's had hyphen in their name so placed them between the brackets and they worked...