>> 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're using FULL Recovery model and accidentally run wrong command (say, instead of select used DELETE )) then you would be able to restore your database to the time before this wrong command occurred and all other transactions would be saved. With simple recovery model you can not do this.
That's a simplistic explanation of the difference between recovery models.
>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.
Good luck!
If it's not broken, fix it until it is.
My Blog