July 25, 2003 at 10:57 am
I scheduled the transaction log backup using Maintenance Plan, then run the job, it always fails, the error message from the job history like 'sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.'
July 25, 2003 at 11:58 am
Two things to check....
First, is the database set to FULL recovery mode? (Use Enterprise Manager, drill down to the database, right click on the database, select properties, go to the Options tab).
If it's not in FULL recovery mode, you CANNOT backup the transaction log.
Second, what is the job set to do after it completes the step successfully? Sometimes this is set for Report Failure. (use EM, drill down to SQLSERVER Agent, expand that and click on JOBS. Right click on the job and select properties. There is a column that shows the response for when each step is successful.)
-SQLBill
July 25, 2003 at 1:09 pm
This is SQL 7, the recovery mode is set to 'Select into/bulk copy', it should not be a problem, the third-party agent can do the transaction log backup without problem, only SQL Maintenance Plan can't. I scheduled the job to run at night, but on the 'Next Run Date' column of the job, it appears 'Date and Time are not available'.
July 28, 2003 at 6:49 am
Is the job ENABLED? Usually when the next run date says what you posted, then it means the job is not enabled.
-SQLBill
July 28, 2003 at 6:54 am
tyang,
Can you check the ERRORLOG for the exact error?! Normally your maintenance report might not show the exact error...
.
July 28, 2003 at 7:27 am
Right click your maintenance plan --> properties --> reporting tab --> check 'text report' to wirte text report to a directory --> run the job --> open above text report to see any error messages.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply