sql server replication: Could not automatically reinitialize -- sql server replication

Could not automatically reinitialize

Ron Sellers
8/31/2005 12:58:05 PM

sql server replication:

I have a series of publisher/ distributors that replicat to one subscriber.
The replication was off-line across the weekend and now most of the
subscriptions are marked inactive / needs reinitialization.

When I try to reinitialize I get a message box saying "SQL Server Enterprise
Manager could not automatically reinitialize this subscription. To
reinitialize this subscription, you must drop and recreate it."

Any suggestions as to places to start looking for a solution will be greatly
appreciated.

Re: Could not automatically reinitialize

Hilary Cotter
8/31/2005 9:36:43 PM

You likely have no-sync subscribers - these always need to be dropped and
recreated, or converted to sync subscribers.

--
Hilary Cotter
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]