Post reply

Backup Transaction Log job failing

  • January 15, 2003 at 10:12 am

    #105581

    Greetings,

    I am getting an error 22029 when I try to run a Transaction Log Backup job when using xp_sqlmaint. I get this error whether I create the job by hand using xp_sqlmaint or I create a DB Maintenance Plan through EM that backs up the Transaction Log.

    I have seen various forums regarding this topic, but none of them have provided the cause or solution. The funny thing is that I create 3 other jobs in this same maintenance plan (including a full DB backup job), and these 3 jobs run fine. Only the Log backup job fails.

    Does anyone have any idea what the problem is?

    Here is the xp_sqlmaint script I use to create the job:

    EXECUTE master.dbo.xp_sqlmaint

    '-D C2000 -PlanName C2000

    -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\C2000_Standard_Hourly_Backups6.txt"

    -DelTxtRpt 4WEEKS -WriteHistory

    -VrfyBackup -BkUpMedia DISK -BkUpLog

    -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'

    Thanks,

  • January 15, 2003 at 11:23 am

    #446400

    Here are some kbs that related to maintenance plans:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288577

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q326485

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;303292

    HTH

    Billy

  • January 15, 2003 at 1:26 pm

    #446419

    Under database options check to see if the truncate log on check point isn't set.

    Do you any nonlogged updates? A DTS package moving a table or rebuilding a table?

    John Zacharkan


    John Zacharkan

  • January 15, 2003 at 2:33 pm

    #446427

    Check maintenance plan history to see any errors reported?

  • January 16, 2003 at 7:53 am

    #446504

    Thanks for the replies.....it was the Truncate log on chkpt setting....it needs to be set to off.

Viewing 5 posts - 1 through 4 (of 4 total)

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