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 - 2003-09-01 : 07:47:41
|
| Colleen writes ">Hi,>>We're using transactional replication from SQL 2000 sp3 to >a subscriber on a SQL 2000 sp2 server. The subscriber is >also the distributor from where the snapshot agent runs.>>The publication does not allow annonymous subscribers. >We're using a push subscription. We use verticle >filtering. >>When we run the inital snapshot we see that it bcp's the >data to the subscriber. However the subscriber never >receives the data. We re-initialized the subscription and >tried again with no luck. We get no errors. When we make >a change at the publisher, the log reader agent says it >delivered 1 transaction but again, the subscriber doesn't >recive it and we receive no errors. However the >distributor agent history says teh snapshot is not yet >available. ???? The snapshot agent reports that a >snapshot with 1 article was generated. We did not >select 'subscriber already has data' option.>>Please help!! We need to get this done by tomorrow. It's >happening on another pair of servers with the same >configuration.>>TIA,>>Colleen>.>" |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2003-09-05 : 20:13:12
|
| It's four days later, and still no answer, but I would love to know what the problem is, we ran into a similar situation, and eventually ported it to another server, with the same configuration, and it worked fine. |
 |
|
|
|
|
|
Replicaion problem-subscriber not receiving snapshot or transactions