Post reply

Log backup Failed

  • June 30, 2008 at 1:34 am

    #193268

    Hi Friends,

    I want a information for Log backup Failure.

    How to Check Logbakup failure?

    Please help for this with step details because i am ne in DBA Field.

    Thanks in Advance,

    Shikha

  • June 30, 2008 at 4:21 am

    #836010

    What kind of information are you looking for?

    The SQL error log usually records log failures with a brief reason. Also the history of the job/maintenance plan should show success or failure.

    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

  • June 30, 2008 at 6:06 am

    #836042

    Hi,

    1)If u want to know whether log backup is failed check sql server event error log.

    2)Then if job is scheduled check job history same as if maintainance plan is scheduled u can check history.

    3)RESTORE VERIFYONLY

    FROM <backup_device

    Verifies the backup but does not restore it, and checks to see that the backup set is complete and the entire backup is readable.

    Check the following

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

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