I work in a small NHS trust in the UK. I am one of 2 developers (my colleague does front end dev for her sins, I stick to database stuff)....

1. You can't restore transaction logs or differential backups unless the database is in norecovery mode.

You don't have to backup the last transaction log before you restore because the...