Results 1 to 3 of 3

Thread: how to decrease transcation log file size in sql server 7.0

  1. #1
    Join Date
    Mar 2005
    Posts
    1

    how to decrease transcation log file size in sql server 7.0

    My Transcation log file size growing to 16GB.There is nospace in that perticular drive.
    ie why i need to decrease size of that transcation log file.

    Can u please do a favour

  2. #2
    Join Date
    Feb 2005
    Location
    yangon
    Posts
    6

    Lightbulb for transaction log

    friend.. how about shrink log file?
    shrink method is shrink the referenced files to be a smallest possiable size but at least should try 3 or 4 times.
    It'll work.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    If you didn't enable db option 'truncate log on checkpount', you have to do log backup periodically to control log size.

Posting Permissions

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