DB maintenance job fails
-
I can't get the DB maintenance job to work.
On the specific job under SQL Server agent it gives this error:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Both the SQL Server Agent and Sql server services are running under it's own account called SQLServiceLogon.
In the \log directory\db maintenance plan.txt has the following error:
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18456: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SQL01\SQLServiceLogon'.
Any ideas?
-
Be sure that this login has rights to connect to SQL Server. Test logging in yourself as this account.
-
There was a bug post sp3 that if you try running your job under a windows account, it will fail even if you have access. I remember running into this. Try changing the owner to sa or apply the latest hotfix.
-
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Same problem here.
Database Maintenance Plans are all failing to run and return the above error message. No warnings. Nothing.
Have created new Database Maintenance Plans and have run the individual jobs and the waited for the DMPs to start automatically. Nothing.
Nothting in the Event Log 'cept for the standard:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan User Databases'' (0x0A87E00B1258A645967A04B1257ACC26) - Status: Failed - Invoked on: 2004-10-20 09:34:01 - Message: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Step 1).
The server is online and running.
The DBCC CHECKDB reveals no problems.
Did a CHKDSK on all drives: no problems.
Checked the RAID controller event log: green.
Restarted the SQL Server Agent Service: ok
Logged in with the SQL Server Agent Account (DOMAIN\SQLExecProd) and connected to the SQL Server: ok
The real funny thing is, that the Database Maintenance Plan History is empty after the 16th Oct. 2004 22:00. Although the jobs should have been running, there are no entries in the DMPHistory for that given DMP.
http://support.microsoft.com/default.aspx?scid=kb;en-us;288577 wasn't a real help. You can't view DMPHistory if you haven't got a history.
Any other ideas guys?
---
Have started the SQLAgent with -c and -v. Not much happening. Was able to backup the databases manually with ISQL/w to the same destination drive.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply