November 30, 2011 at 10:20 am
What day...and it's not even noon here yet :w00t:
We have transactional replication between two 2008 EE SQL Servers (both SP2). Generally we see small errors here and there but today we received a new one that's got me puzzled. A quick Google serach didn't reveal anything work posting or that lead to any sort of resolution so I'm trying here!
The error we're receiving is:
DESCRIPTION:Replication-Replication Distribution Subsystem: agent MYSERVER-MYDB-XX_PUB_TABLES-OTHERSERVER-12 failed. Internal error. The string routine in file e:\sql10_katmai_t\sqltdbms\storeng\dmu\dbcc\source\dumplog.cpp, line 5113 failed with HRESULT 0x8007007a.
What's most puzzling here is the path mentioned above doesn't exist on either server...which makes me think it's being spit out by one of the executables being used in the replication process.
Then we receive another error:
The Distribution Agent reached the end of current command (transaction: 0x0x00064733000133ec013700000000 command 56), but the number of bytes read (23952) is less than the total size (2883634) indicated in command header. When troubleshooting, backup the distribution database and query MSrepl_commands table for the command related to the xact_seqno provided in the error message. (Source: MSSQL_REPL, Error number: MSSQL_REPL21061)
Any thoughts?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2011 at 10:46 am
Sounds like a good opportunity to chat with Microsoft and/or to submit a Connect item on the errors.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 30, 2011 at 1:43 pm
Where are you getting the errors from, the distribution agent or are you querying the distribution database MSrep_errors table?
These are definitely odd errors and I have never seen either. The second one scares me more than the first. The first rings of a snapshot agent but not really.
Let me know if you have more information or if you ended up calling MS on this one.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply