Backup job failure

Question

Backup job failure

sudarram

SSChasing Mays

Points: 623
More actions
August 21, 2008 at 5:50 pm

#189671

Hi,
Im using SQL Server 2000.I configured jobs where each run for minimum 3 hours.Nearly 4 or 5 jobs are scheduled at same time.While the jobs are running,i get an alert that the drive has very low free disk space and minimum one backup job fails.After the completion of all the other jobs i have to manually run the failed one.But the drive has enough freespace.What is the theory behind this?
Thanks in Advance.

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

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

Ray Mond SSCertifiable Points: 7159 More actions · Answer 1

Could you please post the complete error message? Thanks.

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

What are the jobs doing?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

sudarram SSChasing Mays Points: 623 More actions · Answer 3

All are database backup jobs.I have checked the error log files.It simply says that the job has failed,no any reasons for that.

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

Are you running a maint plan that deletes the previous backup ?? If so, then the space problem is caused by the fact that the old backup is not deleted until the new backup has completed. So, for a period of time you have double the backups on your system. If you have 3 backups running at once, then you will have 6 backup files on the server until the new backups complete, then the old backups will be deleted which frees up space.

You can run the jobs in sequence instead of parallel. Or you can do the risky step of deleting the old backup before the new one gets created. It's risky because if the new backup fails, you don't have the previous backup anymore. I used to do this, but I already had the old backup on tape at that point.

Perhaps you can save the backups to tape, or move them to another location before the next nights backup starts.

sudarram SSChasing Mays Points: 623 More actions · Answer 5

Great!!Thank you for your Explanation

Im clear now.Yes,my backup job contains the steps of deleting the old backup and backup database.Even though I have old backup in tape,i supposed to have some backups in disk itself.