I was applying an index to a database with archived data. I knew this would take quite a while. It was at 14 hours running when I left it last night. I came back to it this morning and enterprise manager told me it had lost connection.
On checking activity monitor on the server, I can see the task. Its state is SUSPENDED with a wait type of IO_COMPLETION.
Is there a way to resume this or kill it off and start again?
sp_who2 but it's not being blocked by any other activity and has a status of ROLLBACK. If I then run
kill 61 with statusonly, SQL tells me that;
Status report cannot be obtained. Rollback operation for Process ID 61 is not in progress.
Just looking for options on what I can do/try next. Thanks.