I got a generic error message from the SQL 2000 Maintenance Plan

Asked By 10 points N/A Posted on -
qa-featured

 

I got this generic error message from the SQL 2000 Maintenance Plan but the actual details of the error message 22029 are hidden, how do I go about it?

Errors and/or messages from the job/step run

Job History VIRTUALXP 62613

Errors and/or messages from the job/step run at 1/5/2010 1:56 PM.

Executed as users. NT AUTHORITYSYSTEM. sqlmart.exe failed. [SQLSTATE 42000] [Error

22029]. The step failed.

SHARE
Answered By 0 points N/A #197639

I got a generic error message from the SQL 2000 Maintenance Plan

qa-featured

Hi Richard,

I have found a useful way for you. You could try by running a CMD window and doing the same maintenance plan. You have to copy the JOB properties to a text editor (i.e. trusty Notepad). Then edit it like the below:

C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlmain.exe  -PlanID D9A91AB6-9D8E-40B3-9D11-625747E19FC5 -Rpt "C:Program FilesMicrosoft SQL ServerMSSQLLOGDB Maintenance Plan26.txt" -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog  -UseDefDir  -BkExt "TRN"

Then paste these in the CMD.  After running the command, you will be able to see where the problem is occurring. Use the same account to do this.

Login/Register to Answer

Related Questions