dcsimg
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19

Thread: DBCC SHRINKFILE isn't working

  1. #16
    Join Date
    Sep 2002
    Posts
    5,938
    Why rebuild index when start sql? You can do that during off hours.

  2. #17
    Join Date
    Nov 2004
    Posts
    13
    The whole process is done during off hours. We do a server reboot, disk defrag, and index rebuilding at 2am every Sunday morning.

  3. #18
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Your DBCC Shrink file job should executed after the DBCC reindex job.

  4. #19
    Join Date
    Nov 2004
    Posts
    13
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •