Shrinking log

  • Hi,

    In general how often we can shrink the logs.

    Does shrinking the log will effect the point in time recovery?

  • Shrinking the log will not affect your point in time of recovery. You should look into why you need to keep shrinking the log file though, and consider backing the log up more often or allowing it to reach a larger file size. If you find that you have to shrink the log a lot, it usually means that the log file needs to be larger because of the number of transactions occurring.

  • Ramana3327,

    I would strongly encourage you to read Kimberly Tripp's articles on transaction log management. If you are going to be shrinking log files, it would be a good idea to understand the concept of VLFs within your log file. It will help avoid problems in the future. you can find her articles by going to http://www.sqlskills.com and search the site with "transaction logs".

  • ramana3327 (1/7/2015)


    In general how often we can shrink the logs.

    'Never' is a good frequency for shrinking logs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply