Job Failed.

Question

Post reply

Job Failed.

EasyBoy

SSCertifiable

Points: 5301
More actions
September 13, 2010 at 1:22 am

#226197

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

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

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

Dave Ballantyne SSC-Dedicated Points: 33566 More actions · Answer 1

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[/url]

EasyBoy SSCertifiable Points: 5301 More actions · Answer 2

Hi Dave

Yes it is a Red Gate backup.

Do you think so it might happen because of expiry of Red Gate?

Dave Ballantyne SSC-Dedicated Points: 33566 More actions · Answer 3

Possibly ,

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

Clear Sky SQL
My Blog[/url]

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 4

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.

Peter Peart SSC Enthusiast Points: 157 More actions · Answer 5

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.