DBCC SHRINKFILE isn't working

[rmiao]

Why rebuild index when start sql? You can do that during off hours.

[azuchetto]

The whole process is done during off hours. We do a server reboot, disk defrag, and index rebuilding at 2am every Sunday morning.

[MAK]

Your DBCC Shrink file job should executed after the DBCC reindex job.

[azuchetto]

Thanks for the advice. Next time I do a shrink I will turn off the reindex job. Then if the file doesn't grow, that will be a good indication that the reindexing was the cause of the file growth.