Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer, this is waht i get: The scheduled job 'BACKUP DATABASE FAILED, THE JOB WAS INVOKED BY SCHEDULE 15.Or usually for the wedsday backup failer it eil write, 'the job was invoked by friday schedule, so please any assistance will be highly appreciated.
So do you mean that the backups started working again? What account is the job running as, sqlserver agent and if so is the agent running? Also check disk space. I have seen many admins stuck because they forget to check the amount of space available. I have a Powershell script https://itknowledgeexchange.techtarget.com/dba/powershell-script-to-monitor-disk-space/ that may help with this. I am also writing a series on using Powershell to monitor SQL Server instances. You might want to check those out as well. If you have any question head to http:\\sysadminsmith.com and submit a question for me.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies