• 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