Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database My back job did complete successfully - it must be because the MSSQLSERVER service user profile by default had all the necessary permissions. You change the account for SQL Server by right-clicking My Computer, select Manage. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.Thanks. check over here
The step failed." So it seems to be executing it as NT AUTHORITY\SYSTEM but that seems to being translated into trying to log onto the database under the TESTGROUP\srsqlservice account for sqlmaint.exe failed. The same thing is done for index tuning and database backup (i figured out you should save the files by the default location) and those tasks work. EXECUTE master.dbo.xp_sqlmaint '-D TestDB -Rpt "D:\MSSQL7\LOG\TestDB Transaction Log.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "D:\MSSQL7\BACKUP" -DelBkUps 3DAYS -CrBkSubDir -BkExt "TRN"' 0 LVL 17 Overall: Level 17 MS SQL Server
sqlmaint.exe failed (SQLSTATE 42000) (Error 22029) The step failed Rate Topic Display Mode Topic Options Author Message IceMan-920581IceMan-920581 Posted Friday, October 24, 2008 1:56 AM Grasshopper Group: General Forum Members Last Post back error messages.Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi Wednesday, November 25, 2009 5:26 PM Reply | Quote Moderator Microsoft is conducting an online survey to understand your opinion of Covered by US Patent. cya.
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? SQLMaint.exe Utility Hello All, I am using the sqlmaint utility to backup my database and transaction log. Right? You cannot delete your own topics.
So what I deducted of this experience is that the SQL Agent/OS, ran out of memory to read back the files, since I had set the jobs to verify the backup Help file for a DLL Missing Help Files Problem with Help when using numarray help me? [email protected]#$G maintenance plan!i use t-sql commands and now all is working fine.woohooo!!! Both are owned by SA. 0 LVL 17 Overall: Level 17 MS SQL Server 13 Message Expert Comment by:Barry Cunney2011-11-03 Hi Conor, Is there a proxy account set up on
I have taken over a SQL 2000 db that did not have any backup plans scheduled for it. Join & Ask a Question Need Help in Real-Time? I have found that the problem could be related to security, space and not this problem. What rights does that login have?
Report Abuse. 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 - 23 I ran both these jobs successfully, but when I created a third plan to backup the transaction log it fails with the following message: Executed as user: NT AUTHORITY\SYSTEM. this content There is no proxy account set up on the SQL Server agent. 2.
Do you agree? Username: Password: Save Password Forgot your Password? Thanks for the really good suggestions. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Microsoft SQL Server sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029) If
I look forward to your reply. Find Services, then the MS SQL Server service. NS Jul 20 '05 #1 Post Reply Share this Question 9 Replies P: n/a Greg D. have a peek at these guys So is there anything I can do to fix this problem?
sqlmaint.exe error 7. Solved SQL Server Job permissions query Posted on 2011-11-03 MS SQL Server 1 Verified Solution 14 Comments 955 Views Last Modified: 2012-08-14 I have a issue. Your name or email address: Do you already have an account? About "include files" Help, *.CHM, etc Saved .rtf Help File corrupt after reformatting system Browse more Microsoft SQL Server Questions on Bytes Question stats viewed: 8686 replies: 9 date asked: Jul
The database backs up fine with no errors so it can't be a permission thing and I created the job with a maintenance plan so it has to be in full satya, Nov 8, 2004 #2 rweinstein New Member Satya, No problem with the accounts. rweinstein, Nov 9, 2004 #2 thomas New Member Is it outputting to text file? Gail ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe
The step failed. Toggle navigation my blackbaud all sites sphere login blackbaud labs noza test blackbaud tv netwits thinktank usa uk pacific netherlands canada nonprofit solutions resources support training events partners company my blackbaud You cannot delete other topics. Its really great.
Where are you backing up to? SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! You cannot send private messages.