SQL Server Performance Forum – Threads Archive
transactional replication log reader error
Hello, I am new to replication, and I just set up a transactional replication. When I look in the replication manager, there is a red x on the log reader agent. The error says that "An access violation occurred". I can’t seem to figure out why this is. My subscription isn’t updating, because of this. I have one idea of why it might not be working, and that is that I truncate the transaction log file everynight. Is this possible, and what would the workaround be. The transaction log grows so big that I need to do this, but I also need to be able to do replication. Please let me know what you think. Thanks a lot,Ben
Hi Ben, truncating the log shouldn’t impact replication, since the log has a replication marker and will not allow the log to shrink beyond that marker anyway (the marker being the last transaction to have been replicated) I guess the easiest is to not truncate the log for a couple of nights and check if the error continues. If you really don’t want the log to grow, then set the database recovery option to "simple". This should leave the log at the maximum size required for your largest transaction. If this is still too big, then you may need to work out which transaction is causing this, and seeing if it can be broken up into smaller transactions/batches Cheers
Twan
For that access violation error : Check the log reader agent history for information. Also check whether this KBAhttp://support.microsoft.com/defaul…port/kb/articles/Q243/5/04.asp&NoWebContent=1 is related to the problem. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I went into the log reader error history, and it looks like it is bailing out on the second step, which is to start the log reader agent. Any thoughts would be greatly appreciated. Thanks,
Ben
How about the referred KB article, is that suits? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
no, that was for another version of SQL, and I’m not using any filter. I am having trouble with the log reader agent. Thanks for your help though.
Try starting LoG Reader agent manually by using logread utility, refer to books online for more information. BTW which account is used to start SQLAgent and its privileges?
HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I’ve tried that also, and it doesn’t seem to work either. I use SQL authentication with a user account that I set up myself.
What are privileges for the account setup for SQLAgent? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
where do I check these?
Is that account is a part of local administrator group where SQL is installed?
And also on the other machine involved. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I believe so. I have checked the account that I am using, and I have every possible privilege set up for it. Tonight I will try installing the service packs, and reinstalling the subscription.
BTW what was the error when you tried to start Log Reader Agent? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks for the help everyone. I finally just removed the publication, put on the service packs, and reinstalled the publication, and everything worked.
]]>