Maintenance Plans stopped working

[web4fun]

SQL Server 7.0
NT 4.0 SP4

PROBLEM:

While attempting to cleanup some of the old obsolete databases we took the old / obsolete databases off-line (these were part of an existing maintenance plan) we then created a couple of new maintenance plans to test running a full/complete backup of databases that we do need to backup so for testing we added only two databases to the new maintenance plan yet the maintenance plan never gets past Step 1 (the transact-sql step). We are running everything as the 'sa' user. The Windows Application log via Event Viewer has event id 208 with a description "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan "Test Backup Plan" (0x1FE65EE83E5F5D411BF500002A5070CDB)- Status: Failed - Invoked on: 1/2/07 3:16:34 PM - Message: The job failed. The Job was invoked by User sa. The last step to run was step 1 {Step 1}."

We are just trying to get a "good" clean FULL simple backup of our databases. We will try a reboot of the server to see if perhaps the problem is that the server is too busy. We have verified that we do have plenty of disk space for the backup jobs.

Any suggestions would be greatly appreciated. Thanks in advance.

 

[web4fun]

MORE INFO:

Just discovered that the SQL Server agent is running under a domain account which is not the same account the job runs under which may be the problem???

 

[mrdenny]

Why are you changing to a new maintenance plan. Why not simply remove the databases from the existing maintenance plan?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Who ownes the job? What account is being used to run the job?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"