InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 09:57:24 GMT20http://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxThanks 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_ErrorcodereferenceYou 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 intDECLARE @sqlerrorcode intEXECUTE 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 OUTIF (@exitcode >= 500) OR (@sqlerrorcode <> 0)BEGINRAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)ENDHTH!PetePeter PeartRed Gate Software, Ltd.Wed, 12 Sep 2012 02:40:12 GMTPeter Pearthttp://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxDid 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.Tue, 11 Sep 2012 13:28:49 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxPossibly , try this [url]http://tinyurl.com/2acrnjh[/url]Mon, 13 Sep 2010 03:16:28 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxHi DaveYes it is a Red Gate backup.Do you think so it might happen because of expiry of Red Gate?Mon, 13 Sep 2010 03:05:50 GMTEasyBoyhttp://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxmaster..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 ?Mon, 13 Sep 2010 03:03:48 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic984554-1550-1.aspxWhile i was starting the job i got following error.JOB RUN: 'Full OnlineLogging' was run on 9/13/2010 at 3:03:52 AMDURATION: 0 hours, 0 minutes, 0 secondsSTATUS: FailedMESSAGES: 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 1DECLARE @exitcode intDECLARE @sqlerrorcode intEXECUTE 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 OUTIF (@exitcode >= 500) OR (@sqlerrorcode <> 0)BEGINRAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)ENDError : Msg 50000, Level 16, State 1, Line 6SQL Backup failed with exit code: 510 SQL error code: 0Immediate reply from Senior are greatly appricate.Thanks a lotMon, 13 Sep 2010 01:22:38 GMTEasyBoy