Prev: Maintaining a timely warehouse
Next: Snapshot Replication
From: Bill_Orova on 30 Mar 2010 14:29
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 ***
From: Ben Thul on 30 Mar 2010 14:49
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

On Mar 30, 1:29 pm, Bill_Orova <nos...(a)devdex.com> wrote:
> 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 Developersdexhttp://www.developersdex.com***

 | 
Pages: 1
Prev: Maintaining a timely warehouse
Next: Snapshot Replication