Just wanted some feedback for some small (2GB) SQL 2008 databases and an answer to a question. My backups look like this... 8 am - Full Backup 9, 10, 11 am - Transaction Log Backups 12 pm - Full Backup 1, 2, 3 pm - Transaction Log Backups and so on. First - See any holes? We are comfortable having up to four or five file restore operations used to bring back a down db. I plan to shrink the Trans Log file once a week (via the change in recovery and shrikfile operation). Will this break the log chain?