SQL Server Performance

Differential backups and Transaction Log backups?

Discussion in 'Getting Started' started by boct, Jan 14, 2011.

  1. boct New Member

    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
  2. Luis Martin Moderator

    If I were you I'll continued with Diffs backups.
    Anyway wait for other members opinions.
  3. satya Moderator

    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).
  4. boct New Member

    Thanks Luis and satya
    Confirms my original thought.
    Always like to 'turn the stones over'
    Barry
  5. satya Moderator

    Well thats good but make sure you test them before putting into practice on production [:)].

Share This Page