Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: Tran Log Backup question

    Hi,

    I have my tran log backup running every 30 mins. One of the log backups took 36 mins to complete. So at a time I would have two log backups taking place. It seems to me that the 2nd log back up did not happen at all ( I checked in the EM) as the first one wasn't completed by then.

    I am kind of lost here as to how to proceed.

    Please advise.

    Thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't believe that you need to "proceed" at all. I think that SQL Server fixed the problem all by itself.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Have you checked the history of the job? You can't take a backup (regardless of whether it is trx log, diff, or full) while another backup job is running. If your job took 36 minutes it means that either it was blocked (which is most likely) or the amount of data modifications was too big (in terms of GB's) so that it took that much time. I'd recommend identify the issue, ad if it's the amount of data, then you need to increase the freequency AND implement some CONTROL mechanism, or intelligence if you will, into your job, e.g. create a table that will hold a record when the job starts and delete it when it ends. Before the job can proceed check if there are any records in the table, and if there are, - exit the job.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •