Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles associated with that publisher at snapshot specified location(if its at distributor -would be good). and snapshot agent runs and done. starts applying that snapshot at subscriber which in turns delete the tables and re-create.

but what if you run it several time but nothing happens and you don’t know whats going on, as it don’t provide you the error any where and also it will not show where is it going and what it is doing. for you it’s just like nothing happening.

so what will you do, as we are re-initializing the subscriber so we are safe to delete the subscriber and add the new one which in turns does the same of initialization. so I did so, guess what…. it started working and surprisingly I get error at the replication stating

cannot drop the table ‘xxx’ as its it is being referenced by object ‘yyy’

so now what to do, if you see the object ‘yyy’ its a view with schema binding option enable, due to which table cannot be drop.

this could be also because of function is using that articles(objects). so if  you see re-initialize is not working first check this dependent /reference objects with respect to replicated articles.

This may save some time for some one…



This entry was posted in Add/remove, High Avaliability, Replication, Troubleshooting. Bookmark the permalink.

1 Response to Re-initialize replication not working

  1. Imran Alaskar says:

    Nice job dear 🙂 Imran Alaskar

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.