Transaction logs growing

• James Morrison

  SSC-Addicted

  Points: 455

  More actions

  September 21, 2008 at 7:27 pm

  #191206

  I am an "accidental DBA" at my company. Very limited DBA experience.

  Our transaction logs are growing rapidly.

  Veritas is our backup software and the logs are not being shrunk after the completes.

  What causes transaction logs to grow rapidly? (30 GB per day)

  We use SQL server 2005 as our Datawarehouse ( we extract data from peoplsoft (CRM system) and QAD ( ERP system ).

  Is it OK to run this command to shrink the log files

  USE [DWData]

  GO

  backup log DWData with truncate_only

  DBCC Shrinkfile (DWData_Log);

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  September 21, 2008 at 8:34 pm

  #874768

  Please do not cross post.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]