I'm trying to get a successful subscription push going on my database
publisher after having to alter a couple of tables. After making my
changes, I tried to start the snapshot agent. Normally, I see the
snapshot being created, which takes a few moments. In this case, all
I saw was the old snapshot, created successfully, which was probably
the one I initially did a month ago. I tried to go ahead and push my
subscription, but the status shows as "Deactivated". My question is,
how do I re-push my subscription to my backup database
machine/database?
You can reinitialize the subscription and then it'll pick up the new
snapshot.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
No comments:
Post a Comment