Post reply

usp_ShrinkAllLogs

  • November 7, 2009 at 2:20 pm

    #206316

    Comments posted to this topic are about the item usp_ShrinkAllLogs

  • November 27, 2009 at 2:24 am

    #1084807

    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

  • November 27, 2009 at 11:26 am

    #1084995

    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

  • May 23, 2016 at 4:50 pm

    #1880915

    Thanks for the script.

  • May 23, 2016 at 4:50 pm

    #1880916

    Good or bad I still love the surfing picture.

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

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