• One more thing that's wrong with this - switching to SIMPLE breaks the log backup chain so you lose the ability to do point-in-time recovery. I have no idea why the script needs to switch to SIMPLE - the shrink (although completely not recommended) will work fine in FULL as well - if the author was trying to prevent log files growing, he just needed to mention taking log backups rather than taking the drastic mode of switching to SIMPLE. No enterprise in their right mind is going to use SIMPLE...

    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