Index rebuild job keep on failing in SQL server 2014

Question

Hi,&nbsp;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 almost 5.16TB and free space is 1TB, so to make this job run successful do we need additional space in data drive. Please suggest on this.In addition to this we have so many Heap indexes in the live tables, can you please suggest do we have alternative option for the fix.&nbsp;

javier_villegas · Answer

Hi&nbsp;Sujay1185&nbsp;
&nbsp;
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.
&nbsp;
anyway, I am not sure how you are doing index maintenance but I'll strongly suggest you to check and use Ola&nbsp; 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
&nbsp;
Regards
Javier

Forum Discussion

Index rebuild job keep on failing in SQL server 2014

Resources