How can we help you today? How can we help you today?

Full /Log Backups Don't seem to know what the other is doing

In balancing the maintenance schedule of Full and Log backups for our SQL Servers, we have found that our Full backup will occasionally fail in the Truncate log step of the Full backup, due to the LOG backup running at or near the same time. Are we to assume, or should we always assume that the two backups do not communicate and should be scheduled independently of each other? I think we are assuming that the Redgate backups, like the prodcution SQL Backups, are "aware" of each other, and will not step on each other.

Cheers!
rick.sheeley
0

Comments

1 comment

Sort by
  • petey
    have found that our Full backup will occasionally fail in the Truncate log step of the Full backup
    Could you please clarify what you mean by the 'Truncate log step'? A full backup by itself does nothing to the transaction logs.

    Thanks.
    petey
    0

Add comment

Please sign in to leave a comment.