CirquedeSQLeil (8/24/2010)
If you can only have a couple hours data loss at the max, then enable Full recovery model and setup a backup schedule for your tran logs.As for the duration of the backup:
A differential will backup the changes since the last full all the way to the current. Thus, over time the differential will start taking longer and start getting bigger. But that seems like the closest to what you want.
So you're saying incremental backup is out of the question? If that's the case how about if I create different files for each Database on the Daily biases and over write the files each night?
Thank you.