How to reinitialize a tranactional replication

Hi,
Can any body tell me how to reinitialise a transactional replication.
Regards
Balaji.T
Go to your publication, right click and select reinitialize
That should do the trick.
Regards
"Prabbhu B T" wrote:

> Hi,
> Can any body tell me how to reinitialise a transactional replication.
> Regards
> Balaji.T
|||From the GUI as Zekske points out it is pretty straightforward. Using
scripts it'll be either sp_reinitsubscription or sp_reinitpullsubscription.
In all cases you'll need to subsequently run the snapshot agent then the
distribution agent to get the changes over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .