 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / June 2006Delivering Replicated Transactions
Why would a replication Push go into a status of "Running" and Last Action "Delivering Replicated Transactions", and yet just seem to be hung up there & not finishing. This publication/subscription was running fine for months & now all of a sudden seems to be hanging. The Log reader says X transactions with X commands were delivered, but when I look at the replicated db the rows are not present yet. Sql 2000 - Trans. Rep. Any Push in the right direction would be greatly appreciated. thanx!  SignatureJUDE There could be some large transactions being applied. Run profiler to determine what they might be. You can also look in sp_browsereplcmds to see what is in the queue. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com Why would a replication Push go into a status of "Running" and Last Action "Delivering Replicated Transactions", and yet just seem to be hung up there & not finishing. This publication/subscription was running fine for months & now all of a sudden seems to be hanging. The Log reader says X transactions with X commands were delivered, but when I look at the replicated db the rows are not present yet. Sql 2000 - Trans. Rep. Any Push in the right direction would be greatly appreciated. thanx! -- JUDE |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.