Job Failed.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Job Failed.

Job Failed.

Rate Topic

Display Mode

Topic Options

Author

Message

EasyBoy

Posted Monday, September 13, 2010 1:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:46 PM
Points: 188, Visits: 430

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

Post #984554

Dave Ballantyne

Posted Monday, September 13, 2010 3:03 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

master..sqlbackup is not a standard procedure so cant really comment to much on your exact problem.
It this the red gate SQLBackup ?

Error 510 is generally associated with networking errors.
Are all networked drives etc visible ?

Clear Sky SQL
My Blog
Kent user group

Post #984602

EasyBoy

Posted Monday, September 13, 2010 3:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:46 PM
Points: 188, Visits: 430

Hi Dave

Yes it is a Red Gate backup.
Do you think so it might happen because of expiry of Red Gate?

Post #984606

Dave Ballantyne

Posted Monday, September 13, 2010 3:16 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 10, 2013 4:07 PM
Points: 1,943, Visits: 8,227

Possibly ,

try this http://tinyurl.com/2acrnjh

Clear Sky SQL
My Blog
Kent user group

Post #984608

Steve Jones - SSC Editor

Posted Tuesday, September 11, 2012 1:28 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:26 PM
Points: 31,425, Visits: 13,738

Did you check on any logs from SQL backup, and not just the job?

If the product has expired, it should throw an error, but I'm not sure if this is the one it sends. I've sent a note to Red Gate Support.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1357662

Peter Peart

Posted Wednesday, September 12, 2012 2:40 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 8:13 AM
Points: 11, Visits: 321

Thanks for your post.

As Dave alluded to with his Google search, the problem is that you're trying to overwrite a file with the same name. If you take a look at the below link and search for error code 510, you'll see the definition of the error:

http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.2/SBU_Errorcodereference

You probably want to add additional tags to your T-SQL command, so the file is named automatically on a date / time basis. Something like the below should work for you:

DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [OnlineLogging] TO DISK = ''X:\Backup\<database>\<AUTO>.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

HTH!

Pete

Peter Peart
Red Gate Software, Ltd.

Post #1357839

« Prev Topic | Next Topic »

Permissions