|
Home > Archive > microsoft.public.sqlserver.server > September 2005 > sqlmaint.exe failure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sqlmaint.exe failure
|
|
| Abraham/Raindance Communications Inc. 2002-08-12, 11:23 am |
| When executing this throug a job it fails:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 00096887-CC1A-
463C-89C1-CD01F2AC2776 -Rpt "D:\MSSQL7\LOG\evonyx2 user
db_s6.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -
BkUpLog -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'
Error message:
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
How can I fix this? I am not sure what is wrong. The Sql
Server agent is running and is running under 'system
account'.
Any help would be greatly appreciated.
Abe
| |
| Sue Hoegemeier 2002-08-12, 11:23 am |
| Sqlmaint.exe failed is just a generic error for maintenance
plan failures - you need to check the database maintenance
plan history to get more detail on the error. Right click on
the maintenance plan, and select Maintenance Plan History.
Double clicking on a task will give you more information.
You may want to refer to:
INF: Troubleshooting Database Maintenance Plan Failures
[Q288577]
http://support.microsoft.com/defaul...b;en-us;Q288577
-Sue
On Mon, 12 Aug 2002 09:18:09 -0700, "Abraham/Raindance
Communications Inc." <hot321swap@yahoo.com> wrote:
>When executing this throug a job it fails:
>EXECUTE master.dbo.xp_sqlmaint N'-PlanID 00096887-CC1A-
>463C-89C1-CD01F2AC2776 -Rpt "D:\MSSQL7\LOG\evonyx2 user
>db_s6.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -
>BkUpLog -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'
>
>Error message:
>
>Server: Msg 22029, Level 16, State 1, Line 0
>sqlmaint.exe failed.
>
>How can I fix this? I am not sure what is wrong. The Sql
>Server agent is running and is running under 'system
>account'.
>
>Any help would be greatly appreciated.
>
>Abe
| |
| Abraham/Raindance Communications Inc. 2002-08-12, 12:23 pm |
| Thank you for your response Sue. I read the material you
posted. This is the message from Job History:
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
failed. [SQLSTATE 42000] (Error 22029). The step failed.
I did not see anything in the article regarding permission
issues on sqlmaint.exe. I suspect that the user the
service runs under does not have the appropriate
permissions?
Abe
>-----Original Message-----
>Sqlmaint.exe failed is just a generic error for
maintenance
>plan failures - you need to check the database maintenance
>plan history to get more detail on the error. Right click
on
>the maintenance plan, and select Maintenance Plan History.
>Double clicking on a task will give you more information.
>You may want to refer to:
>INF: Troubleshooting Database Maintenance Plan Failures
>[Q288577]
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q288577
>
>-Sue
>
>On Mon, 12 Aug 2002 09:18:09 -0700, "Abraham/Raindance
>Communications Inc." <hot321swap@yahoo.com> wrote:
>
>>When executing this throug a job it fails:
>>EXECUTE master.dbo.xp_sqlmaint N'-PlanID 00096887-CC1A-
>>463C-89C1-CD01F2AC2776 -Rpt "D:\MSSQL7\LOG\evonyx2 user
>>db_s6.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -
>>BkUpLog -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'
>>
>>Error message:
>>
>>Server: Msg 22029, Level 16, State 1, Line 0
>>sqlmaint.exe failed.
>>
>>How can I fix this? I am not sure what is wrong. The
Sql
>>Server agent is running and is running under 'system
>>account'.
>>
>>Any help would be greatly appreciated.
>>
>>Abe
>
>.
>
| |
| Sue Hoegemeier 2002-08-12, 12:23 pm |
| Abe,
Check the details in the Database Maintenance Plan history,
not through the job. This will give you more details.
-Sue
On Mon, 12 Aug 2002 10:29:21 -0700, "Abraham/Raindance
Communications Inc." <hot321swap@yahoo.com> wrote:
>Thank you for your response Sue. I read the material you
>posted. This is the message from Job History:
>
>Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
>failed. [SQLSTATE 42000] (Error 22029). The step failed.
>
>I did not see anything in the article regarding permission
>issues on sqlmaint.exe. I suspect that the user the
>service runs under does not have the appropriate
>permissions?
>
>Abe
>
>
>>-----Original Message-----
>>Sqlmaint.exe failed is just a generic error for
>maintenance
>>plan failures - you need to check the database maintenance
>>plan history to get more detail on the error. Right click
>on
>>the maintenance plan, and select Maintenance Plan History.
>>Double clicking on a task will give you more information.
>>You may want to refer to:
>>INF: Troubleshooting Database Maintenance Plan Failures
>>[Q288577]
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q288577
>>
>>-Sue
>>
>>On Mon, 12 Aug 2002 09:18:09 -0700, "Abraham/Raindance
>>Communications Inc." <hot321swap@yahoo.com> wrote:
>>
>>>When executing this throug a job it fails:
>>>EXECUTE master.dbo.xp_sqlmaint N'-PlanID 00096887-CC1A-
>>>463C-89C1-CD01F2AC2776 -Rpt "D:\MSSQL7\LOG\evonyx2 user
>>>db_s6.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -
>>>BkUpLog -UseDefDir -DelBkUps 1WEEKS -BkExt "TRN"'
>>>
>>>Error message:
>>>
>>>Server: Msg 22029, Level 16, State 1, Line 0
>>>sqlmaint.exe failed.
>>>
>>>How can I fix this? I am not sure what is wrong. The
> Sql
>>>Server agent is running and is running under 'system
>>>account'.
>>>
>>>Any help would be greatly appreciated.
>>>
>>>Abe
>>
>>.
>>
| |
| awilbourn 2005-09-20, 6:38 am |
| This may be of no value now, but when you are performing transactional backups you need to make sure the databases you want to backup are set to FULL recovery model. |
|
|
|
|