SQL database backup
SQL Server 2000, SQL Server 2000 backup, SQL Server 2000 scheduled backup, SQL Server backup, SQL Server errors, Windows Server 2003
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 11, 2008 8:45 AM
UPDATED:
November 12, 2008 12:51 AM
Answer Wiki:
What shows up in the SQL ERRORLOG?
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
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 http://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.