Post reply

DBCC ShrinkFile

  • 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...

  • 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.

  • May 24, 2004 at 4:28 pm

    #507553

    Thx Xearo.. I´m gonna try

     

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

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