Do I need differential backups or will the transaction logs backups suffice? Database isn't overly large (currently) so restore time isn't really a big consideration. I am currently doing: Full Backup : once weekly (sunday) Diff Backup : daily Trans Log Backup: hourly (7am-6pm) Can I effectively eliminate the Diff backups? Probably best to continue with Diff backups .. just for the fact of perhaps needing to restore to current ..say, on a Friday. Without the Diffs I'd be restoring a plethora of trans logs..correct? thanks barry
I would second Luis opinion here to continue the differential backups, as it will be a long running process to recover the database from backups in case of any disaster. Say on Friday evening if something wrong and you need to restore from the backups means, you have to restore from last full database backup + all the serial transaction log backups (5*24 times).
