If your database has a lot of modifications you may want to push that log backup time down to 15 mins or half hour.

Acceptable data loss window.

Yes. Those are great guide question in implementing a backup strategy.

I would just like to add the following questions as well.

- does your database has a lot of modifications?

- what is you acceptable data loss window.

For example:

if you backup transaction logs every 2 hours,

4pm - tlog backup

6pm - tlog backup

and if something happens to your database (e.g. DB crash, hardware failure) at around 5pm,

then you would lose 1 hour worth of data because you don't have tlog backups in between 4pm to 6pm.

However, if backup t-log every 15 mins, and something happens to your DB at 5:02pm, you will

be able to restore your t-log backup until 5pm so you only have 2 minutes of data loss.

I hope this helps.

Good luck with your backup strategy.

Best Regards,

Ricky