Post reply

Using contig.exe to defragment an open .mdf file

  • August 27, 2013 at 4:32 pm

    #298256

    One of our database .mdf files was set to increase in 1mb increments and is currently in several thousand fragments. Is it safe to use contig.exe to defragment this file while it is in use?

  • August 28, 2013 at 1:28 am

    #1645422

    I wouldn't recommend it. One error in that defragging tool and you have a corrupt database. Better safe, stop SQL or take that DB offline, then defrag it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply