We have a scheduled DBREINDEX job against a 150 GB Database. The data drive is 110GB and Index drive is around 20GB. Log file is around 30GB. The Index job ran fine all these days untill it failed last week saying that the Primary file group is full and it could not allocate space. The drive is left with 10Gb free space and Unallocated space was 25GB within the 110GB itself. The job failed whiled trying to reindex a 7GB table.
My Question here was, would the Reindex job require space for re-organizing on the Primary file group? I expect the Log files to grow but why was it complaining about the Primary file group being full. I havent seen this error before and kind of concerned me.
Ours is Sql2000,8 proc,8GB Ram Box with the SAN Storage.
Pl let me know if anyone has any Idea.
Thanks in advance for ur time