January 25, 2011 at 6:58 am
Hi, I'm runnig a pull subscription (transactional) and want to drop an article from the publisher.
When I try to drop an article in the test environment it says that the subscriptions has to be reinitialized from a new snapshot. I click ok and the replication is still working without reinitializing??
Do I have to reinitialize the subscriptions or not?
I can understand that the snapshot not is up to date but I do not need it (I do not have any snapshot available and do not need any).
Br
Johan
January 26, 2011 at 2:27 am
Hi, anybody knows?
I only want to know if I can drop an article without doing a reinititializion in Sql server 2005?
It seems to be working in my case on a test server but I do not want to do this in production in case of it wants a new snapshot..
February 10, 2011 at 8:07 am
Stop all activity on the database
Stop replication
delete subscription (no subscriptions must exist on the publication otherwise it will require a new snapshot)
drop article
recreate subscription with no initialization
restart replication
February 18, 2011 at 12:49 pm
See link below about adding articles and the 'allow immediate sync' property
http://deepakrangarajan.blogspot.com/2009/01/sql-2005-transaction-replication-adding.html
John.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply