Daily Differential Backup Job Failing

Question

Post reply

Daily Differential Backup Job Failing

Abu Dina

SSChampion

Points: 14155
More actions
November 5, 2012 at 5:13 am

#264246

Good 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:
SQL error log shows:
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?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Viewing 8 posts - 1 through 7 (of 7 total)

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

sanket kokane Hall of Fame Points: 3465 More actions · Answer 1

I cant see Error text :blink:

-----------------------------------------------------------------------------
संकेत कोकणे

Ant-Green SSC Guru Points: 113445 More actions · Answer 2

The 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.

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

Must 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.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Abu Dina SSChampion Points: 14155 More actions · Answer 4

Arrgghhh, 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.

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Ant-Green SSC Guru Points: 113445 More actions · Answer 5

You 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.

Abu Dina SSChampion Points: 14155 More actions · Answer 6

Thanks Anthony.

I've reconfigured the job to output the log to a text file.

Let's see what happens tonight.

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Abu Dina SSChampion Points: 14155 More actions · Answer 7

It 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!

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn