Post reply

Old question: shrink trans logs

  • June 14, 2002 at 3:19 pm

    #57981

    We dump our DB nightly and trans logs hours. Despite this, our "Staging" database has a 1.3GB trans log of which 1.28Gb is free! How can I shrink it easily?

    Note:

    DBCC SHRINKFILE ('Staging_log', 2)

    DBIDFileID Current Size Minimum Size

    152167712 128

    Used Pages Estimated Pages

    167712 128

  • June 14, 2002 at 3:22 pm

    #430942

    If DBCC does not work, check the script library. there is a script I posted that will help you. This has to do with virtual log files within your one log.

    Steve Jones

    steve@dkranch.net

  • June 14, 2002 at 7:28 pm

    #430948

    If you are using SQL 2000 then you will need to run BACKUP LOG dbname WITH TRUNCATE_ONLY to mark logs emptiable. I believe SHIRNKFILE has a parameter as well. If 7 then check the Scripts library under SQL7/2000 and maintaintence for FORCIBLY SHRINK LOG.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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