John,

If you'll check the jobs' history it should give you a little more
detail about why the jobs are failing.

Be sure to turn on the 'Show step details' check box in the job history
view.

* Right click on the Job
* View Job History
* Check 'Show Job Details' checkbox
* Click on the step that failed

HTH,

Stephen Holland
Consultant
Technical Services
PeopleClick, Inc.

-----Original Message-----
From: John F Lewis [mailto:[Email Address Removed]
Sent: Friday, September 26, 2003 8:44 AM
To: LazyDBA.com Discussion
Subject: Failing Scheduled backups.

Intermittanlty the scheduled database backups will not happen.

Any ideas would be appreciated.

The message I'll get in the
system tools -> application -> eventviewer I
s a message from sql agent that the backup
plan failed:

SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DBONE
Maintenance Plan'' (0x359478BD0515AA46BBD1A72F8EB0097C) - Status: Failed
- Invoked on: 2003-09-25 02:00:00 - Message: The job failed. The Job was
invoked by Schedule 4 (Schedule 1). The last step to run was step 1
(Step 1).









---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
MS Sql Server LazyDBA home page