Shrink large MDF file

• Raymond van Laake

  SSCarpal Tunnel

  Points: 4212

  More actions

  September 17, 2012 at 8:54 am

  #266761

  Hi,

  We had a little incident on our production server that caused a table named 'Log' to grow to 2 million records. That was fixed by recreating that table as 'Log1', dropping 'Log' and renaming 'Log1' as 'Log'.

  The LDF log file grew to 97GB and the MDF data file to 38GB; their normal size should be around 4GB.

  How can I resize them to a normal size?

  Thanks,

  Raymond

• raghava_tg

  Ten Centuries

  Points: 1014

  More actions

  September 17, 2012 at 8:58 am

  #1538658

  use DBCC shrinkfile(filename, 0).

  it shirnks unused a memory...it works..!!!