Posted on 2011-04-19
Last Modified: 2012-06-27
We started getting an error in part of our maintenance plan.  This has been running forever and within the last week, started erroring out.

Event Type:      Warning
Event Source:      SQLSERVERAGENT
Event Category:      Job Engine
Event ID:      208
Date:            4/19/2011
Time:            7:27:28 AM
User:            N/A
Computer:      SERVER01
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Non AA database backup'' (0xFB47AEB8DD6DED4898606D6E954CAC8E) - Status: Failed - Invoked on: 2011-04-19 07:27:26 - Message: The job failed.  The Job was invoked by User MES\administrator.  The last step to run was step 1 (Step 1).

EXECUTE master.dbo.xp_sqlmaint N'-PlanID D1772498-25D5-45D6-9C9D-2317BBB65CC5 -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP_TRN" -DelBkUps 4DAYS -BkExt "TRN"'
Question by:yostnet
    LVL 39

    Accepted Solution

    Is that all you het from the Job history on that maintenance plan?
    Was/is there any entry in the Event Viewer on that SQL Box besides this?
    Was there any database dropped/moved recently that is still part of the Maintenance Plan?
    Is there enough space for backups?

    Author Comment

    hmm | guess it has not run in quite some time.

    is there a way to reset the TRN maintenance plan?
    LVL 2

    Assisted Solution

    Where is your backup going? Local drive, remote networked drive or tape?

    Has anything changed with your network. How much space is free on your disk or tape?

    How much space is available in MSDB and master. I have seen backups error out if there is not enough space in these databases. SQL does not grow these databas well and can fail when trying to grow.

    Author Comment

    goes to a local drive.

    Nothing has changed |

    disk space is about 3gb or so.

    LVL 2

    Expert Comment

    How about the available space in MSDB and master
    LVL 75

    Assisted Solution

    by:Anthony Perkins
    >>Nothing has changed<<
    You need to start with the premise that something has changed.  Contrary to popular belief computers do not wake up one morning with a headache and decide not to work.  If you can at least accept that then will have a better chance of finding the problem.

    For example, have you checked the Windows Event Log for errors?
    Have you checked the detail from the SQL Server Agent "View History" option?
    Have you tried executing the maintenance job from the SSMS query window with a valid login?
    What is the startup account used by the SQL Server Agent service?  A domain account, a local sytem account, something else?
    LVL 75

    Expert Comment

    by:Anthony Perkins
    And another question:
    Do you have a valid Full backup for the database?

    Author Closing Comment

    thx all

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now