January 7, 2015 at 9:19 am
Hi,
In general how often we can shrink the logs.
Does shrinking the log will effect the point in time recovery?
January 7, 2015 at 9:29 am
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.
January 14, 2015 at 10:47 pm
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".
January 15, 2015 at 1:46 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply