Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I tried to find the answer and came across these MSDN pages but they don't actually explain what happens really:

http://msdn.microsoft.com/en-us/library/ms152771.aspx http://msdn.microsoft.com/en-us/library/ms189701.aspx

Step by step what does the Reinitialize All Subscriptions option actually do to the database in SQL Server Management Studio 2008?

enter image description here

share|improve this question
    
I am looking for a detailed response ideally as like I said, the MSDN pages don't go into details rather one or two sentences that roughly describe the whole process not each step! –  CodeBlend Jun 16 at 13:34

2 Answers 2

what does the Reinitialize All Subscriptions option actually do to the database in SQL Server Management Studio 2008

Reinitialize Subscriptions marks all the subscriptions to a publications for reinitialization. It apply a snapshot to each subscriber.

Refer to Reinitialize Subscription(s) - All Subscriptions

share|improve this answer
    
Can you expand upon this what step by step actually happens during this process e.g. tables get dropped and re-created –  CodeBlend Jun 16 at 13:33

When you reinitialize subscriptions, entire snapshot of articles ( schema, data..) Is generated and stored in folder. So next time when distributor agent runs, instead of incremental changes.it takes the snapshot generated and applies it to subscriber.

share|improve this answer
    
Can you expand upon this what step by step actually happens during this process e.g. tables get dropped and re-created –  CodeBlend Jun 16 at 13:33
    
Well... in different words your whole snapshot will be transferred to every subscriber. This is last thing which your should do ;) If your snapshot has 10GBs and you have few subscribers and you are using internet for replication it will take long time. As option for you can start replication from backup for every subscriber. With this approach you can control rein it process step by step. –  Kuba Miazek Jun 17 at 18:47

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.