Results 1 to 2 of 2

Thread: Transaction Log Size doesn't show correct

  1. #1
    Join Date
    Oct 2002
    Location
    US
    Posts
    5

    Transaction Log Size doesn't show correct

    Hi All,
    I have a production database in SQL 2000 server. It is configured to truncate on check point. when ever I check the log size by right click on database and choose property and then logfile the size is keep on showing the ever growing transaction file size. I truncated the logfile and restarted the server. No new news.
    The transaction log file is set to unlimited growth.
    Can you please tell me how do i get the file shrink to its orginal value?? The files are set to shrink files option.
    Any advice would be gratly appreciated. (The Transaction file size is 41 gig, initially it was set to 1gig)

  2. #2
    Join Date
    Nov 2002
    Posts
    4
    Jay,

    I too had problems with non-truncating log files, but in SQL7.

    I ploughed through reams of stuff in BOL and MSDN, but the crux was
    issue DBCC shrinkfile,
    then do a backup log truncate only

    e.g.:

    DBCC shrinkfile ( <log file name>, <size to shrink to in mb> )
    go
    backup log <DB Name> with truncate_only
    go

    so for my instance:

    DBCC shrinkfile ( Tracker_Log, 1000 )
    go
    backup log Tracker with truncate_only
    go

    It may not show staright away as this only marks it for truncation,
    and it can not truncate whilst any part of the file is active,
    but as soon as it can shrink it should do.


    Cheers sduggan...

Posting Permissions

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