DBCC ShrinkFile

• Eduardo-135196

  SSC Rookie

  Points: 42

  More actions

  May 24, 2004 at 3:48 pm

  #102031

  Hi everyone... I´m trying to compact my log database file using dbcc shrinkfile but nothin happening.

  Do you´ve got any idea...?? Or what could I do to compact these DB ?

  Regards...

• Xearo

  SSC-Addicted

  Points: 448

  More actions

  May 24, 2004 at 4:22 pm

  #507551

  Hi,

  Before shrinking use

  BACKUP LOG WITH TRUNCATE_ONLY

  and then do

  DBCC SHRINKFILE(2)

  (I am assuming that you have only one log file)

  This should work.

  Regards.

• Eduardo-135196

  SSC Rookie

  Points: 42

  More actions

  May 24, 2004 at 4:28 pm

  #507553

  Thx Xearo.. I´m gonna try