Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: SHRINKDATABASE and LOG File

    Hi all, after using "DBCC SHRINKDATABASE (MyDB, TRUNCATEONLY )" command my log file stoped growing. It still remains 1024KB after 4-5 days of activity. What might be the problem?

  2. #2
    Join Date
    Jun 2003
    cape town, south africa
    it has 1024 space allocated to the log, but it isnt necessarily using all of that space. it will grow when it has filled all of that - i wouldnt worry about it - nothing would be happening if their really was no log activity.
    in enterprise manager/db properties you can see how much free space is available in the allocated amount...

Posting Permissions

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