Home > Error En > Error En Sqlmaint.exe

Error En Sqlmaint.exe


rino19ny Starting Member Philippines 2 Posts Posted-07/18/2011: 07:58:44 WOOOHOOOO!!!!!i fixed it! sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). Please activate Javascript in your browser settings. rweinstein, Nov 7, 2004 #2 satya Moderator Ensure the SQL Server service account has required privileges to deal the files and see whether those files are accessed by any other process

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. Huckleberry, Mar 28, 2013 #14 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is You cannot edit other topics. If you have set the plan to try to repair problems, make sure this box is un-checked.

Error En Sqlmaint.exe

Was this article helpful? the database is 200GB and i have allocated a 1TB drive for the destination.how else to fix or know the cause of the problem? We've got lots of great SQL Server experts to answer whatever question you can come up with.

Does anyone have any ideas on how to de-bug this error? All rights reserved. Does anyone have any ideas on how to de-bug this error? You cannot post or upload images.

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed If you click on the Plan properties and Click on the "View History" button under the "Reporting" tab, you will
see the following text, not sure about the exact sentencing, Privacy statement  © 2016 Microsoft. The folder is not writeable to the Windows Account that runs the SQL Server (SQLEXPRESS) service.

plan was failing with essentially the same problem. Thanks for this forum. This is very quirkey. The step failed.

  1. Any ideas what I'm missing?
  2. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. I checked the MSDN for info on this error and this did not add any extra light on the problem.

Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. https://kb.blackbaud.com/articles/Article/39851 ThrasherCary P. Error En Sqlmaint.exe You cannot edit your own events. You cannot post topic replies.

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] The step failed." This is the only error message to be found in any of the logs. 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). HTH ------------ Sidney Ives at 4/30/01 2:41:16 PM I'm having the same problem.

Rate Topic Display Mode Topic Options Author Message Cary P. You sometimes get more useful information from there about what's going on than from the SQL Server Agent job history. I found that by changing the time of the backup, it was running into my process that copies the backup to another server. I don't know why, but this seems to have worked for me.

Not the answer you're looking for? In short, the workaround for me was to set the MSSQLSERVER service torun underthe user's WinNT Domain\User account. You cannot post events.

Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?

I checked the MSDN for info on this error and this did not add any extra light on the problem. I have found that it is very helpful on telling you what went wrong, which for me was usually a wrong setting. You cannot post replies to polls. plan to begin outside of the db backup.

the resolution to my error was to register SQLDMO.DLL in C:\Program Files\Microsoft SQL Server\80\Tools\Binn. I removed a ton of space and it failed again last night with there being 55GB free space, when the DB is only 16GB. All Forums General SQL Server Forums New to SQL Server Administration how to fix [SQLSTATE 42000] (Error 22029) Reply to Topic Printer Friendly Author Topic rino19ny Starting Member Philippines 2 To start viewing messages, select the forum that you want to visit from the selection below.

So is there somebody know a solution for my issue ? Chat with Support Chat with our experienced staff to receive help right away. On my SQL box, it seems that a BackupExec job runs under the NT System Account on the SQL's local OS - this is preventing single-user mode. Thanks Emmanuel sql sql-server sql-server-express sql-server-2008r2-express share|improve this question edited Dec 7 '12 at 6:13 marc_s 452k938641029 asked Dec 6 '12 at 21:51 Emmanuel 62 add a comment| 1 Answer 1

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. The step failed." This is the only error message to be found in any of the logs. We at PROVISIO wish you Merry Christmas and a Happy New Year! Report Abuse. {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Windows apps Windows phone

You cannot delete your own events. I changed the MAINTENANCE PLAN name to match the JOB name that was automatically created by the system. All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback Toggle navigation my blackbaud all sites sphere login blackbaud labs noza test blackbaud tv netwits thinktank usa uk pacific netherlands canada nonprofit solutions resources All of the other db on this server have the same plans (run as the same user, backup to the same directory,) but they all work fine.