Deepak-405225
SSCertifiable
Points: 6120
More actions
June 12, 2008 at 3:16 am
#827710
Are you taking transaction log backup and then shrinking ? Refer this which explains about [font="Verdana"]Log file growth in Sql Server.[/font]
[font="Verdana"]- Deepak[/font]
alen teplitsky
SSC-Dedicated
Points: 30014
June 12, 2008 at 9:43 am
#827963
i have databases where the log file is over 100GB and i leave it alone
shrinking files is bad for performance, especially if you have multiple files on the same disk
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply