sql server replication: Automate reinitialization -- sql server replication

Automate reinitialization

Duy Nguyen
6/25/2007 3:55:26 PM

sql server replication: Currently, we have many MSDE instances that subscribe to our main server.
Morning, we have to re-init whenever there's a failed subscription.

Is there a way or script to automate the reinitialization? Also, how can
we indicate it to use the current snapshot or generate a new snapshot?

Thanks in advance!

Duy

Re: Automate reinitialization

Hilary Cotter
6/25/2007 10:04:15 PM

Schedule the Reinitialize subscriptions having data validation failures job.
I would create a schedule that runs twice a day.

--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]