Shrinking Transaction Log the right way

• yassargo

  SSC Rookie

  Points: 39

  More actions

  June 9, 2012 at 9:44 am

  #259227

  Hello All,

  We are trying to shrink a huge transaction log. The database recovery model is FULL. I am not a SQL expert, thus I would appreciated if you could provide me with detailed steps on how to accomplish this task based on BEST PRACTICES. I have looked at a lot of blogs and post and they all have different approach and don't tell you if their approach have a bad consequences.

  Thanks

  Yassar

• David Stokes

  SSC Veteran

  Points: 237

  More actions

  June 9, 2012 at 10:28 am

  #1499030

  Please check out

  http://www.sqlskills.com/BLOGS/PAUL/post/Importance-of-proper-transaction-log-size-management.aspx">

  http://www.sqlskills.com/BLOGS/PAUL/post/Importance-of-proper-transaction-log-size-management.aspx

  This should give you a start at understanding the transaction log and how to manage it. The folks that blog on SQL SKILLS are experts when it comes to SQL server

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 9, 2012 at 3:16 pm

  #1499055

  Please read through this - Managing Transaction Logs[/url]

  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