> Using simple recovery model you should be able to recover to last night version. All latest day transactions will be lost.
Well, I do believe that this is what I want. The backup procedures I dealt with so far were all in the same targets. That is the most important goal. If something happens in the morning, for example, I would like to recover from the midnight backup. Because, the goal of recovering from a backup is to recover from a point that you know everything was ok. So, if a drive corruption happens in the morning, making the MDF a no go, then a full backup restore from the overnight backup would be the way to go.
If you have comment in regards to that, I would be interested to hear about it so I can collect more information on the topic in regards to how SQL Server manages it.
>Do you have DBA? You need to test periodically your backup / restore procedures.
Yes, but not at my place. :) I will do a full backup and do this test.