Post reply

Transaction log backup failled

  • March 14, 2011 at 3:12 pm

    #233241

    One of our maintenance plan for database transaction log backup failed.

    Before that there is a successful differenticial backup.

    Then the transaction log backup runs every 6 hours, currenly there are consective 4 failed.

    I cannot find why it failed by looking at job history. By looking at maintenace log, I can see the job status succeeded, but there is no trn backup file.

    I recreated the transaction log backup job.

    My question is: if I do a manual run- by manual I mean click the job, and run- of the transaction log backup job, do I need to do another differential backup before that- I mean since the previous 4 transaction logs backup all failed, is it necessary to run a diffrencial backup so that the transaction back up can be successful?

    Thanks

  • March 14, 2011 at 3:34 pm

    #1298597

    I just did a manual run, and it immediately failed. The job history is as follows,

    Date3/14/2011 2:29:03 PM

    LogJob History (MaintenancePlan.Transaction Log Backups)

    Step ID1

    ServerMy server

    Job NameMaintenancePlan.Transaction Log Backups

    Step NameTransaction Log Backups

    Duration00:00:06

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: Myserver\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:29:03 PM Progress: 2011-03-14 14:29:07.88 Source: {290BD89F-4680-4D2B-A154-4046774A81E3} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:29:03 PM Finished: 2:29:08 PM Elapsed: 5.063 seconds. The package execution failed. The step failed.

    Where can I get more information for troubleshooting the error?

    Thanks

  • March 14, 2011 at 3:43 pm

    #1298601

    You should be able to get more information in the SQL Server Logs, under the Management Node. Look at the most recent log file.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • March 14, 2011 at 3:51 pm

    #1298603

    Thanks, But there is no any error related with the transaction log backup.

  • March 14, 2011 at 4:39 pm

    #1298612

    I figured out. Thanks

  • March 14, 2011 at 7:52 pm

    #1298642

    Would you mind posting what the problem was and how you solved it? It could help someone else later on.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • March 16, 2011 at 5:49 pm

    #1299734

    I found it's a bug in SQL server.

    when I choose backup the following database, but next time when I open it, it didn't save the result.

    I have to specific check the box in front of them again.

    My server is 2005 SP2

  • March 17, 2011 at 7:34 am

    #1299934

    I HIGHLY recommend you stop using maintenance plans to do your sql server maintenance. Go to ola.hallengren.com and use the suite of scripts and jobs (FREE) found there. Complete documentation and incredible flexibility and power.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 17, 2011 at 8:46 am

    #1299972

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/

  • March 17, 2011 at 8:49 am

    #1299976

    annasql (3/16/2011)

    My server is 2005 SP2

    SP3 has been out for a loooooooong time ....

  • March 17, 2011 at 1:54 pm

    #1300198

    homebrew01 (3/17/2011)

    annasql (3/16/2011)

    My server is 2005 SP2

    SP3 has been out for a loooooooong time ....

    Actually SP4 has been out for quite a while now . . .

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 17, 2011 at 3:06 pm

    #1300248

    builds of 2005 http://www.sqlservercentral.com/articles/Administration/2960/

  • March 17, 2011 at 5:49 pm

    #1300297

    Thanks all.

    How long does it take to apply service pack 3?

    Thanks

  • March 18, 2011 at 3:11 pm

    #1300822

    You ought to apply SP4, and it only takes minutes. The install is relatively short.

Viewing 14 posts - 1 through 14 (of 14 total)

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