Post reply

Job Failed

  • September 13, 2010 at 1:25 am

    #226808

    While i was starting the job i got following error.

    JOB RUN: 'Full OnlineLogging' was run on 9/13/2010 at 3:03:52 AM

    DURATION: 0 hours, 0 minutes, 0 seconds

    STATUS: Failed

    MESSAGES: The job failed. The Job was invoked by User name The last step to run was step 1 (execute master..sqlbackup). The job was requested to start at step 1 (execute master..sqlbackup).

    Here is the step 1

    DECLARE @exitcode int

    DECLARE @sqlerrorcode int

    EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [OnlineLogging] TO DISK = ''X:\Backup\FULL_OnlineLogging.sqb'' WITH COMPRESSION = 2, ERASEFILES_ATSTART = 10, MAILTO_ONERROR = ''sqladmin@snl.com'', MAXTRANSFERSIZE = 262144, THREADPRIORITY = 1, THREADCOUNT = 4"', @exitcode OUT, @sqlerrorcode OUT

    IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)

    BEGIN

    RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)

    END

    Error : Msg 50000, Level 16, State 1, Line 6

    SQL Backup failed with exit code: 510 SQL error code: 0

    Immediate reply from Senior are greatly appricate.

    Thanks a lot

  • September 13, 2010 at 2:54 am

    #1219901

    Please don't crosspost. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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