Post reply

What if Transaction Log Backups Overlap?

  • April 4, 2011 at 4:11 am

    #235067

    What would happen if, say, I set Transaction Log backups to every minute and they overlapped? Would it result in a loop of some sort that never ends?

    Regards

    Steve

  • April 4, 2011 at 5:22 am

    #1306912

    If you're talking about scheduling via SQL agent, there can only be one instance of a job running. If a job is still running when it's next start time arrives, SQL Agent won't start the job again.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 4, 2011 at 6:36 am

    #1306941

    Oh OK - so if an agent job is about to start it will be missed if the same job is still currently running.

    thanks

    Steve

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply