Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Fri, Sep 28 2007
Filed under: Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing