MDF File size is growing fastly...

• Chowdary's

  SSCrazy

  Points: 2978

  More actions

  July 28, 2014 at 5:29 am

  #310401

  Hi Experts....

  I have a Problem like the Following ..

  On 24th my Mdf size was 10GB,when i checked now the Mdf size was increased suddenly to 30GB.

  Please give me some solution to decrease the Size and as well as where can i check the reasons behind that..

  Awaiting for your valuable Response...

  Regards

  Chowdary...

  Regards
  Chowdary...

• Hardy21

  SSCrazy Eights

  Points: 9708

  More actions

  July 28, 2014 at 5:54 am

  #1732779

  What kind of data are you storing in your MDF file? It may possible that fragmentation playing role here.

  refer: http://msdn.microsoft.com/en-IN/library/ms188917.aspx

  Thanks

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  July 28, 2014 at 6:31 am

  #1732792

  all replys here http://www.sqlservercentral.com/Forums/Topic1596764-1550-1.aspx#bm1596804

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉