Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    PHILIPPINES
    Posts
    9

    Unanswered: Trucate Transaction Log

    Hello,

    Can you help on how to truncate and minimize the size of transaction log .


    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63
    Hi!

    The easiest way should be to use SQL Server Enterprise Manager. Do a right-click on the database and select Shrink Database.

    Greetings,
    Carsten

  3. #3
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You can not shrink the footprint unitl you empty the log, run a

    backup log dbname with truncate_only

    before your shrink file command

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •