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

Asked By Richard L Brown 10 points N/A Posted on - 01/31/2013

 

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?

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.

• Status: Open
• Question Views: 728
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Jemison Stacy 0 points N/A #197639

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

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.

About Jemison Stacy

Questions
3

Answers
102

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 02/10/2013
• Question Category: MS SQL Server