Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Job Failed. Expand / Collapse
Author
Message
Posted Monday, September 13, 2010 1:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:41 PM
Points: 207, Visits: 475
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
Posted Monday, September 13, 2010 3:03 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 1,949, Visits: 8,315
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
Posted Monday, September 13, 2010 3:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:41 PM
Points: 207, Visits: 475
Hi Dave

Yes it is a Red Gate backup.
Do you think so it might happen because of expiry of Red Gate?
Post #984606
Posted Monday, September 13, 2010 3:16 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 1,949, Visits: 8,315
Possibly ,

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




Clear Sky SQL
My Blog
Kent user group
Post #984608
Posted Tuesday, September 11, 2012 1:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:00 PM
Points: 33,204, Visits: 15,354
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
Posted Wednesday, September 12, 2012 2:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse