locked
Replication Production issue,Urgent please help!! RRS feed

  • Question

  • I have sql server 2005, I am having an issue where the transactions are sitting at the distributor and not going to subscriber.
    And I am seeing a pending status under distributor to subscribur. This replication is a continuous Transactional replication
    and not updatable.

    Please help!!


    sqldev
    Sunday, February 28, 2010 7:37 PM

All replies

  • What is the exact error message you are getting and where do you see it?
    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Sunday, February 28, 2010 11:56 PM
    Answerer
  • you should run the following statement

    use distribution

    go

    select * from msrepl_errors order by 2 desc

    there you should see the error. Then with the transaccion id (xact_id I guess) use it for the next statement

    sp_browsereplcmds '[xact_id]'

    there you should see the pending replication commands

    Saturday, April 10, 2010 12:45 AM