October 13, 2008 at 4:54 am
Hi,
I'm getting the below message when viewed in the job history of 'transaction log backup' maintenance plan.
"The job failed. The Job was invoked by Schedule 200 (Schedule 1).
The last step to run was step 1 (Step 1)."
Also the below error when viewed in the event log.
"Error 22029 Database. ... error sqlmaint.exe failed."
How can I know the cause behind this?
Although, the error relating to this is not logged in the errorlog.
thanks in advance 🙂
October 13, 2008 at 5:09 am
Check the sql agent log and job history for more information on why the maintenance plan fail. Did you changed the job owner? Some time this might be the reason. Once done with the checking try to run the job once again manually and check if this was successfull. If still you find issue check the above log and paste the error.
"More Green More Oxygen !! Plant a tree today"
October 13, 2008 at 8:24 am
You can set the main plan to log all errors to a text file. In SQL 2005 and 2008 that's done by selecting the 'Reporting and Logging' button from the maint plan's toolbar.
Set it to log to a text file and you'll be able to see the full error message.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 2:53 pm
Check whether you have applied latest SQL Server service pack(SP2 refresh version) on the server
Cheers ! 😉
January 14, 2009 at 1:23 am
Although it may be a little late for answering your questions, it may be useful for other people. Check if your database recovery model is Simple. You can not perform Transaction Log Backup on simple recovery mode databases. In that case you can change the recovery model of the databases from SIMPLE to either FULL or BULK LOGGED.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply