sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029

Question

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029

scottsanpedro

SSCrazy

Points: 2130
More actions
April 24, 2002 at 3:26 am

#151684

I have just come back from holiday and the following error opccured and made the database fail when a normal transaction Log backup was performed
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Anyone put some light on this why it has happened.
Thanks in advance
Scott

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Check out these items on the MS KB Site http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=22029&Queryc=22029&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 and see if any of those apply. Usually is related if you are trying to do a transaction log backup of master or have an expiration set.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

scottsanpedro SSCrazy Points: 2130 More actions · Answer 2

Thanks for the answer..the links have helped. the error i got is as follows

[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 240(The session was cancelled.) detected during read of BUF pointer = 0x14651a00, page ptr = 0x63290000, pageid = (0x1:0xe6ac), dbid = 9, status = 0x801, file = \\Dimensql\MSSQL7\DATA\GMCPUBS.mdf.

mean anything???

thanks again Scott

Antares686 SSC Guru Points: 125444 More actions · Answer 3

Sorry I find no details on this error in particular nor have I come across it. What service pack is on your server and did you check both the SQL logs and EventViewer logs to see if anymore details?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

This corresponds to a message back from the OS...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q186549

What, if anything was going on with the server at the time? As Antares has asked, what do the Event Logs say, especially the one for System?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

K. Brian Kelley
@kbriankelley

scottsanpedro SSCrazy Points: 2130 More actions · Answer 5

At the time of the failure there was a transaction log back up occuring. This failed.

On the Application error log there were plenty of errors showing. Interestingly there are couple showing Network errors. May well be the solution to this.

Thanks for your help again

Scott