Shrinking Transaction Logs

• nitin1353

  SSC-Addicted

  Points: 449

  More actions

  June 11, 2008 at 11:07 pm

  #122969

  Gurus

  My logfile for a DB grows very rapidly and grows to more than 10gb every night,i have scheduled a job to shrink this file.

  Now in job activity monitor it is showing me a yellow triangle in front of the job and status as successfull and it has ran only for 1 second

  It is not shrinking the logs

  I have transactional replication implemented

  My point is when the logfile grows more than 10 gb the job does not shrink the logs

  I have got around 8 steps in thos job and this is the 7th step

  Please Advice

  Thanks

  Nitin

• 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

  More actions

  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