SQL database backup

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.

Answer Wiki

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

What shows up in the SQL ERRORLOG?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,185 pointsBadges:
    report
  • Colin Smith
    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.
    885 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following