Post reply

Help with DB backups and TSM Archive

  • March 17, 2009 at 9:00 am

    #201921

    I have a maintenance plan running on SQL Server 2000 sp4 that makes a database backups and then uses TSM command to archive the bak files to tapes.

    I have been having issues

    1. My backup runs successfully and the files gets archived to tapes successfully too but after both steps are complete I get message that the step failed.

    any suggestions would be great..

    Thanks,

    Venkat.

  • March 17, 2009 at 9:17 am

    #961142

    Any specifics on your error message and/or anything in the SQL Server error log?

  • March 17, 2009 at 9:35 am

    #961163

    all I get is an error

    "The step did not generate any output. Process Exit Code 8. The step failed."

    No other information else.

  • March 18, 2009 at 1:23 am

    #961626

    Check your job to make sure it is not set to close with failure.

    And the last step in the job is configure to return success/failure ..

    On your second post it says the step failed? So are you sure you data got backed up to tape properly?

    Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

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

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