Automate reinitialization

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duy Nguyen - 25 Jun 2007 23:55 GMT

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

Reply to this Message

Hilary Cotter - 26 Jun 2007 03:04 GMT

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

Signature

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

> Currently, we have many MSDE instances that subscribe to our main server.
> Morning, we have to re-init whenever there's a failed subscription.
[quoted text clipped - 5 lines]
>
> Duy

Reply to this Message