It best if you are logged onto the SQL Server using the same account as the SQL Server Agent account. The same configuration (Account = Local System) works wonderfully for the other 95% of my users. Connect The Blackbaud team is online and ready to connect with you! plan was failing with essentially the same problem. this content
No, create an account now. Try this article to see if it will help.http://support.microsoft.com/default.aspx?scid=kb;en-us;288577 Post #129159 sivaprasadsivaprasad Posted Thursday, July 7, 2005 5:48 AM SSC Veteran Group: General Forum Members Last Login: Tuesday, April 12, 2016 I stopped backing up my trans log with my database. Username: Password: Save Password Forgot your Password? http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx
Example: EXECUTE master.dbo.xp_sqlmaint N'-PlanID D9A91AB6-9D8E-40B3-9D11-625747E19FC5 -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\DB Maintenance Plan26.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog -UseDefDir -BkExt "TRN"‘ Remove the xp_sqlmaint call and add the sqlmain.exe. I hope this helps,Diarmuid. Tom Pullen DBA, Oxfam GB thomas, Nov 9, 2004 #2 rweinstein New Member Just an FYI that I resolved this issue. This backup command is ignored":
As advised by MSFT, i did the following:
Maybe it's running when the backup attempts to run.Have you right clicked on the failed job and selected View Job History? Catadmin - MCDBA, MCSA"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???" RE: Error 22029 - It appears, no matter what scedule may have been created for this task, evry time the database is backed up SQL will perform the integrity checks... Master.dbo.xp_sqlmaint Parameters Additional info is that I set the plan to delete any backup old than three months, which hasn't been reached yet.Error received - sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).
regards Stuart Ainsley Reply With Quote 04-30-2001,01:41 PM #2 Sidney Ives Guest failed maintenance plan [SQLSTATE 42000] (Error 22029) (reply) I'm having the same problem. Sqlstate 42000 (error 50000). The Step Failed I've checked event viewer, the SQL error logs, exception log, maintenance plan log, sysdbmainplan_history table in msdb, but can't find any extra information. smedvid (MIS) 8 Aug 05 08:21 Strange, I have a similar issue... Catadmin - MCDBA, MCSA"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???" RE: Error 22029 -
Home Articles Tips FAQ Books Software SQL Server Scripts Forum   Log in or Sign up SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 https://kb.blackbaud.com/articles/Article/39851 Once I did that, my backup plan was successful. Sql Server Error 22029 Maintenance Plan You cannot post new polls. Xp_sqlmaint Characters Remaining: 255 Blackbaud Community Connect and collaborate with fellow Blackbaud users.
Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. http://rlegsoftware.com/sql-server/262-error-sql-server.php Post #128881 Diarmuid HurleyDiarmuid Hurley Posted Thursday, July 29, 2004 12:03 PM Forum Newbie Group: General Forum Members Last Login: Friday, November 15, 2013 1:41 AM Points: 9, Visits: 9 I've Chris SkorlinskiMicrosoft SQL Server Escalation Services Comments (0) Cancel reply Name * Email * Website Follow UsPopular Tagssp_cycle_agent_errorlog skip invalid transaction replication LSN DBA sp_cycle_errorlog Best Practices sp_readerrorlog sql 2005 2008 satya, Nov 8, 2004 #2 rweinstein New Member Satya, No problem with the accounts. Sqlmaint.exe Failed.
Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Post #198705 joshcsmith13joshcsmith13 Posted Monday, July 11, 2005 9:06 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Wednesday, November 25, 2015 2:09 PM Points: 509, Visits: 252 fyi. You cannot post events. have a peek at these guys The step failed when backing up the database When performing a scheduled or manual backup, you may receive the following error and the backup does not complete: 'SQLMAINT.EXE failed. [SQLSTATE 42000]
That’s why it is easier to track these down while logged on as the same account used by SQL Agent. Dbcc Checkdb Most ran correctly, but as you can see the Transaction Log backup of MDB failed which caused the Maintenance Plan job to fail with the generic error 22029. And I'm only dealing with a one user local MSDE setup.
Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? The step failed when backing up the database' Article Number:39851 Products: Education_Edge_EE Financial_Edge Microsoft_products Raiser_s_Edge Student_Billing Possible causes: The Log On As Service account for the SQL Server service does not By joining you are opting in to receive e-mail. Often you’ll encounter a permissions/authority problem.
Catadmin (Programmer) (OP) 3 Aug 05 10:48 I've set up Transaction Log backups for a database (no optimization, no integrity checks since this database is the read only product of replication You cannot delete your own topics. Just that step failed.What may be happening, is that when a backup finishes, the verify starts, but before it can begin another backup may be starting. http://rlegsoftware.com/sql-server/233-error-in-sql-server.php You cannot delete other posts.
Catadmin (Programmer) (OP) 3 Aug 05 13:11 Ahhh.Now there's something I hadn't considered.Thanks, SQLBill. @=)Will definately check job times when I get into the office. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. If you have set the plan to try to repair problems, make sure this box is un-checked. I've had an open issue with MS for over a month now, trying to get this figured out.
You cannot send private messages. I only execute the backup step, I do not perform any other maintenance within that job.I perform shrink and optimization in seperate database jobs.Those jobs always succeed.My backup job does perform Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 22 I checked the MSDN for info on this error and this did not add any extra light on the problem.
Red Flag This Post Please let us know here why this post is inappropriate. It fails intermittantly with the message: "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). You cannot delete your own events. The step failed.
Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!