Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
transaction replication failing
1 view
Skip to first unread message
Bill_Orova
Mar 30, 2010, 2:29:23 PM3/30/10
to
Hello Gurus,
We have a transactional replication running between two production
SQL2K5 servers, one server is the publisher and the distributor while
the other is only a subscriber. At this point the replication monitor
is showing a running status. The row count between the two servers is
off. We ran the initialization, the monitor and verification of the
snapshot. Everything showed okay except for the initializtion of the
snapshot. This failed. The message said that the snapshot agent was
not present. Attempts to reinitalize the snapshot failed as well.
HELP!
Wisord
*** Sent via Developersdex http://www.developersdex.com ***
Ben Thul
Mar 30, 2010, 2:49:20 PM3/30/10
to
Take a look at the sp_addpublication_snapshot stored procedure. It
will add a snapshot agent for your publication and record what it is
at the distributor.
--
HTH,
Ben
will add a snapshot agent for your publication and record what it is
at the distributor.
--
HTH,
Ben
0 new messages