Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

sql2008, what happens when rerun the replication snapshot

Hi,
I already have replication working in our server, but I want to know what happens when I run the snapshot again ? does it again apply full snapshot if I rerun ? or it just apply new articles ? which earlier have not been published ?
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>I want to know what happens when I run the snapshot again ? does it again apply full snapshot if I rerun ? or it just apply new articles ? which earlier have not been published ?<<
It depends, whether you select to reinitialize or not.
Avatar of motioneye

ASKER

Hi,
So when I select for reinitialize, the whole snapshot will be distribute again into subscriber, hint new set of data in subscriber instead only new articles only applied.
So when I select for reinitialize, the whole snapshot will be distribute again into subscriber
Yes.
hint new set of data in subscriber instead only new articles only applied.
I don't understand.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial