Log Reader Agent problem

  • My log reader agent shows failed status and last action : 'An access violation occured' after I finished creating publication. What would the cause of this problem ? How to work around this problem ?

    Thanks in advance

  • Need more info I think. If you look in BOL for the logreader it shows how to enable logging (-outputverboselevel 3 -output c:\repl.txt I think). Can also log in the SQL log folder to see if a dump file was created that might have more details.

    Andy

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

  • Also, have you installed service pack 3.

    I was also having this problem, installed sp3 and it all worked fine.

Viewing 3 posts - 1 through 3 (of 3 total)

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