April 10, 2002 at 12:49 pm
Hi I have several maintenance plans that include transaction log backups. Every Trans log backup fails (they are scheduled hourly) any idea why.
This is the error I get in job history:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
April 10, 2002 at 4:56 pm
Yes, thats helpful! Can you do a transaction log backup yourself, using either EM or TSQL in Query Analyzer?
Andy
April 10, 2002 at 6:11 pm
SOme reasons these might fail are , truncate log on checkpoint is flushing the logs (rare but does happen to throw errors for this) or bulk insert (no logged transactions) are being done.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 16, 2002 at 3:15 pm
I just posted the same errors.
Your entire TLOG backup is not failing, only part of it. To see what failed go to the maintenance plan and right click on the plan and go to job history that will tell you what is failing and what is working.
There is also a line you can add to the Agent to write to a log file... If you need it email me.. I have to locate it
"I don't know what tomorrow holds
but I know who holds tomorrow."
"I don't know what tomorrow holds
but I know who holds tomorrow."
April 16, 2002 at 6:01 pm
Check these out on the MS KB site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=Error%252022029&Queryc=Error+22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply