Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-09 : 09:16:51
|
| Richard writes "I have transactional replication set up between two servers. The production server is the publisher and the reports server is the distributor and subscriber.We receive monthly updates to data in the system from the states that we work for. Two nights ago I performed an upload of fresh data to our production database. The data contained a refresh of Payor and Employer information for the system. There are four tables involved and all of them are replicated. The refresh completely replaces the data in them. Table sizes range from 150,000+ rows to 319,000+ rows.Since that night the distribution agent hasn't failed. However it has 'Delivering replicated transactions' in the 'Last Action' column.This is a problem for us. The state of NC uses that database to provide reports and there is no data on the subscriber for yesterday. The log reader agent shows that it was copied to the distributor, however there it has stopped.Any ideas?Richard L. DawsonDatabase AdministratorICQ# 867490" |
|
|
|
|
|
Replication - Delivering replicated transactions....