Results 1 to 2 of 2

Thread: Shrink log file

  1. #1
    Join Date
    Jun 2002
    Posts
    9

    Unanswered: Shrink log file

    Hello,
    I have a MS SQL Server 2000 database which has around 2GB of
    transaction log file. I did 'database shrink' on logfile.
    But size of log file has not reduced ??
    anybody knows why ??

    thank you

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    This has come up in past postings see them below:
    Transaction Log shrinking mysteriously...
    Gargantual Transaction Files
    Transaction logs

    Hopefully some of these will help.
    MCDBA

Posting Permissions

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