Transaction Log backup via SQL Maint fails

[Dilbert]

I have setup a SQL maintenance plan to backup the transaction log file to be backup every one hour M-F.

But now I have been getting the following error:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Any clues what does this error mean ?

Thanks.

[Ray Miao]

Any message in sql error log?


------------
Dilbert at 7/5/2002 11:14:32 AM


I have setup a SQL maintenance plan to backup the transaction log file to be backup every one hour M-F.

But now I have been getting the following error:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Any clues what does this error mean ?

Thanks.

[rogerjh]

there should be an output file somewhere - look in your script on the scheduled task for the location of the output file. That file should tell you what happened.


------------
Ray Miao at 7/5/2002 1:08:57 PM

Any message in sql error log?


------------
Dilbert at 7/5/2002 11:14:32 AM


I have setup a SQL maintenance plan to backup the transaction log file to be backup every one hour M-F.

But now I have been getting the following error:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Any clues what does this error mean ?

Thanks.