SQL database backup

4511

5 pts.

Tags:

Microsoft SQL Server 2000

Microsoft Windows Server 2003

SQL Server 2000 backup

SQL Server backup

SQL Server errors

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.

Asked: November 11, 2008 8:45 AM Last updated: November 12, 2008 12:51 AM

Answer Wiki

Last updated: November 11, 2008 10:38 PM GMT

Denny Cherry68,435 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,435 pts.

Thanks. We'll let you know when a new response is added.

What shows up in the SQL ERRORLOG?

Discuss This Question: 2 Replies

Denny Cherry Nov 11, 2008 10:38 PM GMT

Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.

68,435 pointsBadges:

report
Colin Smith Nov 12, 2008 0:51 AM GMT

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.

945 pointsBadges:

report