• John, Gail -

    Put simply, "I hadn't thought of that". Thanks for the input.

    Without intending to hijack the thread, there are several other considerations involved:

    1) I'm at a regional bank, and the Full and Differential take place in non-bankers-hours, no users online at that time

    2) The weekly full backup is part of a multi-step maintenance job that also performs DBCC CHECKDB, index rebuilds, etc. It first performs a "Final" Log Backup, then changes to SIMPLE, performs the maintenance, then changes back to FULL immediately before the Full backup step.

    3) I always perform the first log backup immediately following the completion of either the Full or Differential.

    But with what you've shown me I think I can immediately cease disabling the log backup, at least during the differentials.

    Mike Hinds Lead Database Administrator1st Source BankMCP, MCTS