jpSQLDude (5/16/2011)
Ninja's_RGR'us (5/16/2011)
Well it doesn't <completely> break it. that's why I said I preffer to have that run with full backups as first and last steps.
I'm pretty sure the instant you set your database to SIMPLE Recovery model with ALTER DATABASE [PROD] SET RECOVERY SIMPLE you just broke the log chain. No?
Yes it does. In my case the whole script runs in less than 6 minutes (full backup included). So the break in the log chain is not an issue here.
But I understand it can be for you or anybody else with slower disk subsystems.