During the execution of maintenance plan, it rebuilds the indexes on the tables. An ALTER INDEX command is executed, but the command stalled and hung the maintenance job. Error that was reported in the log said it failed (see the error message below).
I am not sure what to do with this error or how to fix the error. Appears to be a problem with the index [a215_ix1_a] being used for the table [a255].
What could I do to resolve the error?
Rebuild Index (TOMLINSON)
Rebuild index on Local server connection
Object: Tables and views
Original amount of free space
Task start: 2010-08-16T10:17:13.
Task end: 2010-08-16T12:18:07.
Failed:(-1073548784) Executing the query "ALTER INDEX [a215_ix1_a] ON [cf_pbtf].[a255] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )
" failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.