usp_ShrinkAllLogs

  • Brandon Forest

    SSCommitted

    Points: 1806

    Comments posted to this topic are about the item usp_ShrinkAllLogs

  • Chris Howarth-536003

    SSCommitted

    Points: 1775

    Hi Brandon

    How often do you run this stored procedure, and why?

    I'm just trying to understand under what scenario you would want to shrink all transaction logs.

    It would be a good idea to indicate in the article that regularly shrinking log files is not a recommended practice. I can see a newcomer to SQL Server reading the article and interpreting it as meaning that regularly shrinking log files is a good idea.

    Chris

  • Paul Randal

    One Orange Chip

    Points: 29438

    Hear, hear. As is, this article is terrible. You don't explain any of the reasons for doing this (or more importantly, not doing it).

    You also say you must take a full backup to reestablish the log backup chain - not true - you can take a differential backup instead - potentially smaller and faster. You just need something to bridge the missing LSN gap.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Good or bad I still love the surfing picture.

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

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