Copyright © 2002-2016 Simple Talk Publishing. My job now runs to success. Error 22029 - SQLMaint.exe fails but works? 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... this content
That’s why it is easier to track these down while logged on as the same account used by SQL Agent. I have found that it is very helpful on telling you what went wrong, which for me was usually a wrong setting. Below is the MP script: EXECUTE master.dbo.xp_sqlmaint N'-PlanID EB943500-B818-425F-B9B8-20EBE92FFC8D -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDB -BkUpMedia DISK -BkUpDB "Erogram FilesMicrosoft SQL ServerMSSQLBACKUP" -DelBkUps 1DAYS -BkExt "BAK"' Thanks. Our new SQL Server Forums are live!
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 We've restricted the ability to create new threads on these forums. 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 - Xp_sqlmaint I have had several reasons for this error.
dbasql, Oct 8, 2007 #3 AGE_mx New Member If someone else have this problem, I verify security access and after that and some test I found that one error source could Sql Error 3202 Happy SQL administration! The step failed. 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,
i made sure that the destination disk have enough space but i still get the error: Executed as user: NT AUTHORITY\SYSTEM. Sqlmaint.exe Failed. Apparently, due to in improper installation, the dll was not registered for all users of the system. To do this, copy the JOB properties to your favorite text editor or use trusty Notepad.exe. So, i renamed this file to something else
and then executed the plan again.
So, what this was doing was locking the file, so the maintenance plan could not delete it. https://kb.blackbaud.com/articles/Article/39851 It almost looks like nothing got backed up and since there wasn't anything to verify, it failed.-SQLBill Posting advice: FAQ481-4875 RE: Error 22029 - SQLMaint.exe fails but works? Sql Error 22029 Backup Its really great. Sql 2005 Error 22029 This was to ensure if data needed prior to month end load, data would be avaialble.
What I can tell you from my experience, is that if I configure the MSSQLSERVER service to run under a Domain\User account that has admin priveledges to the machine, everything works Often you’ll encounter a permissions/authority problem. 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 - 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. Sql Error 22029 . The Step Failed
In short, the workaround for me was to set the MSSQLSERVER service torun underthe user's WinNT Domain\User account. In my example, the CMD window displayed the results of every action. sefarkas, Feb 27, 2009 #6 JCAlexandres New Member My maintenance plans were running fine for long time, as soon as the database reached 18GB I started experiencing problems when the SQL Come on over!
SQLBill (MIS) 3 Aug 05 13:09 Quote (Catadmin):If a verify of a backup fails, it automatically deletes the backup right?NO. Master.dbo.xp_sqlmaint Parameters Another reason for the jobs to fail is obviously lack of disk space if backing up to disk. DennyMCSA (2003) / MCDBA (SQL 2000)--Anything is possible.All it takes is a little research. (Me)http://www.mrdenny.com (Not quite so old any more.) RE: Error 22029 - SQLMaint.exe fails but works?
Red Flag This Post Please let us know here why this post is inappropriate. Re-executed the plan, but the same silly message.
3. You cannot delete your own posts. Sqlstate 42000 (error 50000). The Step Failed You may find this technique works for other SQL Agent errors.
Most often SQL Agent jobs are not this easy to track down. You cannot post replies to polls. JCAlexandres, Nov 23, 2007 #7 nickf New Member Have also had this crop up a lot recently (in plans written by soemone else!), and have found a further solution. Click Here to join Tek-Tips and talk with other members!
I logged into SQL Server under another user and reset the default database for the user running the job and problem solved! You cannot post new polls. You cannot post IFCode. DennyMCSA (2003) / MCDBA (SQL 2000)--Anything is possible.All it takes is a little research. (Me)http://www.mrdenny.com (Not quite so old any more.) RE: Error 22029 - SQLMaint.exe fails but works?
Feedback Please tell us how we can make this article more useful. 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 You cannot delete your own events. If it isn't, maybe try setting it to and see what is produced.
You cannot delete your own topics. Best way to determine underlying error is to run the same maintenance plan JOB from a CMD window. 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. My suspicion is that because this "step 1" of the plan also contains the deletion of files older than 1 day, that maybe this last setp failed after the backup was
smedvid (MIS) 8 Aug 05 08:21 Strange, I have a similar issue... And I'm only dealing with a one user local MSDE setup.