Post reply

log backup failed

  • November 8, 2010 at 2:53 am

    #228673

    how to identify log backup chain is broken and where it is broken

  • November 8, 2010 at 3:19 am

    #1247552

    vijay82 (11/8/2010)

    how to identify log backup chain is broken and where it is broken

    check under SQL Agent, Jobs (right click), view history/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • November 8, 2010 at 3:28 am

    #1247560

    Please explain your question more.

    Are you asking why a log backup failed or are you asking how to find when someone broke the log chain (by a switch to simple recovery and back) or are you asking something else?

    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

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

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