I removed a ton of space and it failed again last night with there being 55GB free space, when the DB is only 16GB. tia, Steve Medvid"IT Consultant & Web Master"http://www.saveourfarm.comChester County, PA Residents Please Show Your Support... 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 thread962-1102086 Forum Search FAQs Links MVPs Error 22029 - SQLMaint.exe fails but works?
Register now while it's still free! i made sure that the destination disk have enough space but i still get the error: Executed as user: NT AUTHORITY\SYSTEM. You cannot delete other topics. Post #199379 sivaprasadsivaprasad Posted Thursday, July 14, 2005 2:13 AM SSC Veteran Group: General Forum Members Last Login: Tuesday, April 12, 2016 11:17 AM Points: 285, Visits: 269 Have a look
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] You cannot edit other posts. 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. Xp_sqlmaint The step failed.
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 Happy SQL administration! So, what this was doing was locking the file, so the maintenance plan could not delete it. https://support.microsoft.com/en-us/kb/326485 Forgot your password?
Try each of the following steps in the order listed until the issue is resolved: Un-register and re-register the SQLDMO.dll file located at C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQLDMO.dll or C:\Program Files (x86)\Microsoft Sqlmaint.exe Failed. So, i renamed this file to something else
and then executed the plan again. rweinstein, Nov 9, 2004 #2 thomas New Member Is it outputting to text file? We've restricted the ability to create new threads on these forums.
You cannot send emails. 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. Sql Error 22029 Backup Thanks. Sql 2005 Error 22029 Catadmin (Programmer) (OP) 3 Aug 05 16:22 Job duration was all of 16 seconds.Here's the error message from the log (with names changed for privacy reasons):Quote (ErrorFile):Job 'TransLog_Backup_for_MyDB' : Step 1,
You cannot edit HTML code. No, create an account now. 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 Was this article helpful? Sql Error 22029 . The Step Failed
When the job fails the details for the error are hidden and all you get is the generic 22029 error. Copyright © 2002-2016 Simple Talk Publishing. 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 - I haven't tested that.
You cannot edit your own events. Master.dbo.xp_sqlmaint Parameters Also remove the N’ in the beginning and the trailing ‘ (single quote). To locate the service account for SQL Server: Click StartType services.msc and press EnterIn the window that launches, scroll down to locate the service titled SQL Server (INSTANCE NAME) Scroll to the right to
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! 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. Characters Remaining: 255 Blackbaud Community Connect and collaborate with fellow Blackbaud users. Sqlstate 42000 (error 50000). The Step Failed Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc.
Maybe it's running when the backup attempts to run.Have you right clicked on the failed job and selected View Job History? Catadmin (Programmer) (OP) 3 Aug 05 17:20 The problem is, there is no file to verify.That's why I was wondering if a failed verify deleted the file.The file supposedly succeeds and 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 - The next thing i could do was look into the table that was mentioned in the option
adjacent to the "View History" button.
select * from msdb.dbo.sysdbmaintplan_history
You cannot upload attachments. ThrasherCary P. Username: Password: Save Password Forgot your Password? I found that by changing the time of the backup, it was running into my process that copies the backup to another server.
Re-executed the plan, but the same silly message.
3. 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 It should end up like: C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmain.exe -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" Next open a CMD window That’s why it is easier to track these down while logged on as the same account used by SQL Agent.
Are you aComputer / IT professional?Join Tek-Tips Forums! sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). Thrasher Posted Wednesday, July 28, 2004 12:25 PM Valued Member Group: General Forum Members Last Login: Tuesday, February 20, 2007 7:17 AM Points: 69, Visits: 1 At my Company, I set