Post reply

Transaction log backup failed message

  • January 5, 2009 at 6:59 pm

    #383684

    we have a transaction log backup job runs every 30mins. it backs up 4 databases. once a while, we receive email saying that job failed. when I look at the job history. it shows failed too. however, sql server log did not show any error on that backup. I also check the backup directories (each database has its own subdirectory), all 4 TRN backup files are there. can anyone tell me why I am getting the job failed message?

    our sql server is 9.0.3159 standard edition

    here is the info in job history:

    [font="Arial"]Date1/5/2009 10:10:00 AM

    LogJob History (User Databases.Transaction Log Backup)

    Step ID1

    Servercorp-prod\instan1

    Job NameUser Databases.Transaction Log Backup

    Step NameTransaction Log Backup

    Duration00:00:06

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: DM\sqlsupper. ...sion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 10:10:00 AM Progress: 2009-01-05 10:10:03.17 Source: {3B15AC30-CB78-4EA9-91F7-B73BD01FE008}

    Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-01-05 10:10:03.41

    Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\C_PROD".: 25% complete End Progress Progress: 2009-01-05 10:10:03.41

    Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\C_PROD".: 50% complete End Progress Progress: 2009-01-05 10:10:03.41

    Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\C_PROD".: 75% complete End Progress Progress: 2009-01-05 10:10:03.41

    Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_crea... The package execution fa... The step failed.[/font]

    Thanks in advance,

  • January 5, 2009 at 7:26 pm

    #921535

    This appears to be a duplicate of:

    http://www.sqlservercentral.com/Forums/Topic630261-357-1.aspx

    Posted at 8:58 PM

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 5, 2009 at 7:48 pm

    #921539

    I am sorry. I was doing the preview before ready to post it...somehow, it is posted twice. I was trying to delete one, but it is still there....can you let me know how to remove of the two?

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

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