Home Forums SQL Server 2005 Administering DBCC Shrinkfile & Shrinkdatabase RE: DBCC Shrinkfile & Shrinkdatabase

  • March 21, 2008 at 7:23 am

    #792423

    Mohan Kumar (3/20/2008)

    use

    DBCC shrinkfile (filename, expected size in MB , notruncate)

    once this is completed then

    DBCC shrinkfile(filename, expected size in MB , truncateonly)

    This will do trick.

    Thanks Mohan, will give it a try.

    Mark, thanks, the log is under control - Currently at 100 MB:)