Thanks for this Kenneth - very useful! I have an observation on backing up to share vs local disk - there are in fact pros and cons either way. Certainly, with a local only backup, there is a risk that a local disk failure could take out both your backups and your data files if you have them both on the same disk. However, disk failure isn't the only risk and I'm quite keen on the extra speed that a local backup can give, combined with the ease and speed of restore. Here are my thoughts, for what they're worth:
!. Backup! Have a thought-out, well planned backup and restore regime - know your Recovery Point and Recovery Time Objectives, have your storage set up right, think through all the scenarios and implications
2. Perform a test a restore regularly so that you know how to do it, you know it works, you know you have enough free space, you know how long it takes etc.
3. Backup both to a local drive AND to a network share if at all possible (there are various ways to do this: 3rd party software, network copies etc.)
4. On the local server, place data, log and backup files on separate sets of drive spindles with appropriate RAID if using DAS - discuss it with your storage manager if using a SAN (but don't accept "it's a SAN so it's fine")