Post reply

Shrinking Transaction Log the right way

  • 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

  • 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

    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

  • 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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply