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.
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
"Ron Sellers" <RonSellers@.discussions.microsoft.com> wrote in message
news:2DB36478-12BA-431A-A5D7-10952637A116@.microsoft.com...
> 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.
>
Friday, February 24, 2012
Could not automatically reinitialize
Labels:
across,
automatically,
database,
distributors,
microsoft,
mysql,
off-line,
oracle,
publisher,
reinitialize,
replicat,
replication,
series,
server,
sql,
subscriber,
weekend
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment