I have an SQL Rebuild Index task which fails to complete. It ran fine for well over a year but for some reason it now runs but doesn't seem to finish.
I have run all the alter statements individually on a restored test database and all semed to run fine. I ran them individually on the live sytem and eventually I came accross statements which didn't finish.
There are no errors in the event viewer or in the SQL Logs mainly I think because the job isn't actually failing.
Any thoughts on what may be casuing this or ideas on any troubleshooting steps would be much appreciated.