Post reply

Troubleshoot failed SQL server agent job with backup file copied to the destination

  • May 15, 2009 at 5:03 am

    #134415

    Hi,

    In SQL server agent i had scheduled a backup job to run on daily basic.

    It will place the copy of the backup file in the destination that i specified.

    The job history says that the job failed.

    But i can find the backup files copied to the destination.

    I need to know how the backup was copied to the destination even if the job failed?

    The log doesn't provide much information.

    Thanks.

  • May 15, 2009 at 6:24 am

    #995233

    Can you post the error message from Job History?

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • May 15, 2009 at 6:33 am

    #995249

    I got the error message as follows.

    sqlmaint.exe failed [Error 22029]

    Thanks,

    Keerthi

  • May 15, 2009 at 7:48 am

    #995334

    http://support.microsoft.com/kb/288577

    To identify the specific task and error message about why the job failed, you need to check the Database Maintenance Plan History. The Database Maintenance Plan History is where you can obtain detailed information about each task that is being performed by the maintenance plan. Use these steps to locate the information in the SQL Server Enterprise Manager:

    1. Navigate to and then expand Database Maintenance Plans.

    2. Right-click the Database Maintenance Plan for which the corresponding job failed.

    3. Click Database Maintenance Plan History.

    4. A window opens that contains details about each task performed in the Maintenance Plan. A historical list is provided for each task run on each date, which also indicates the failure or success status of the individual task. If you double-click a failed task, information displays indicating any error messages that occurred along with information about why the task failed.

    5. Take the necessary steps at this point to resolve the specific issue indicated.

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • May 17, 2011 at 10:52 pm

    #1326237

    Hi

    I have the opposite situation. I take a backup, compress it and send it to a remote location. The SQL server shows its success but could not find an file at the location. The job success every time I run manually but don't works when its in schedule

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

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