Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

usp_ShrinkAllLogs Expand / Collapse
Author
Message
Posted Saturday, November 7, 2009 2:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 11:13 AM
Points: 65, Visits: 366
Comments posted to this topic are about the item usp_ShrinkAllLogs
Post #815475
Posted Friday, November 27, 2009 2:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:37 PM
Points: 278, Visits: 1,071
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
Post #825492
Posted Friday, November 27, 2009 11:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 3, 2014 11:47 AM
Points: 2,038, Visits: 1,664
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
Post #825711
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse