Forum Discussion
Index rebuild job keep on failing in SQL server 2014
Hi, Created a index rebuild job in SQL agent and for the past few weeks it keeps on failing. Troubleshooted from my end and I suspect the drive space is less in data drive were the MDF file is al...
Hi Sujay1185
It is important to see the error message that you are getting. if you have free space on the disk means that database file is not growing so maybe autogrowth is set to none.
anyway, I am not sure how you are doing index maintenance but I'll strongly suggest you to check and use Ola Hallengren solution which will provide a very detailed log in case you have failures
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
Regards
Javier