December 27, 2005 at 9:12 pm
i have a maintenance plan to backup transaction logs for 5 databases, it backs up file but shows an error as follows.
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
can someone help me idedntify the root cause of the issue.
Thanks ina dvance
Joby(UserID=270470)
December 30, 2005 at 8:00 am
This was removed by the editor as SPAM
January 2, 2006 at 9:11 am
Most likely one or more of your databases is in simple recovery mode, which will cause a maintenance plan transaction log backup to fail.
Look in the maintenance logfile for any further details. For the location of these logfiles check the reporting tab in your maintenace plan. If the recovery model of one or more database is simple you should see some messge saying the database has been skipped.
Markus
[font="Verdana"]Markus Bohse[/font]
January 2, 2006 at 8:39 pm
Hi Marcus
Thank u very much for the post. It really helped me. Thanks a lot.
Joby
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply