Daniel,

Thanks for taking the time to share this script. I have a question though.

Wouldn't your transaction logs backups that are performed AFTER you shrink the logs and return to FULL recovery model fail unless you first perform another FULL database backup ?

If you try to make a log backup in this situation, I believe the transaction log backup will fail with a "no current database backup" error

My understanding is that when you change from SIMPLE to FULL recovery the database still behaves as if it is still in SIMPLE mode (sometimes called "pseudo-simple") until a full backup is performed.

Shaun Stewart has an article about this problem here:

http://shaunjstuart.com/archive/2013/01/determining-if-a-full-backup-is-needed-for-a-log-or-differential-backup/#ixzz2zB0AglRz

Paul Randall also has an excellent article this at:

http://www.sqlskills.com/blogs/paul/new-script-is-that-database-really-in-the-full-recovery-mode/

Thanks again.

Lee