InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 12:27:55 GMT20http://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxIt turns out that two of my databases didn't have full backups which explains why the differential backup job failed.Thanks for the suggestion Tony!Tue, 06 Nov 2012 09:35:28 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxThanks Anthony.I've reconfigured the job to output the log to a text file.Let's see what happens tonight.Mon, 05 Nov 2012 07:38:31 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxYou will need to set the job to log to an output file then in the properties of the job which will capture the full output so that it can be reviewed on another failure.Mon, 05 Nov 2012 07:21:51 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxArrgghhh, the above output is actually the last part of the string from the job log history table so I'm afraid it's all I've got to work with.Mon, 05 Nov 2012 07:16:35 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxMust be the moon. I'm going through the same thing with a full backup that failed twice over the weekend. Once well before the time change and once after. The backup actually completed and then it said that the connection could no longer be resolved. Like you, I have plety o' space on the backup drive.Mon, 05 Nov 2012 07:02:05 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxThe output of the text in the log file viewer for a job is only the top X amount of characters, the error will be somewhere else down the output, so either query the sysjobhistory table to get the full output or log the output to a file which you can review should the error happen again.Mon, 05 Nov 2012 06:55:32 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxI cant see Error text :blink:Mon, 05 Nov 2012 06:04:41 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1381005-146-1.aspxGood afternoon,I have a SQL Job which performs nightly differential backups of all databases on one of my production servers. Unfortunately the Job failed last night but I'm struggling to work out the cause of the problem.The SQL Job error is:[img]http://s18.postimage.org/za1w69895/backup_Job.jpg[/img]SQL error log shows:[img]http://s15.postimage.org/xsv1r9vuz/SQLError_Log.jpg[/img]Please note that the database name in the SQL error log is not the same name in the SQL Job error. Although I've masked the database name, I can tell you that there are different.I also checked space on the NAS and there's plenty of it.Any ideas?Mon, 05 Nov 2012 05:13:40 GMTAbu Dina