sql2008, what happens when  rerun the replication snapshot

motioneye
motioneye used Ask the Experts™
on
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 ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
normaly, it will just apply new articles which earlier have not been published
Commented:
IT will just apply new articles provided that you have added them after your first snapshot. Else it will just log a message that there were no subscriptions need to be initialized.
Top Expert 2012

Commented:
>>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.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
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.
Top Expert 2012

Commented:
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.
Commented:
.. make it short : -- add your new articles -- go to your publicaton snashot sql agent  job and run it-- > monitor from Repl manager  -- > see  that just new articles have been replicated.

In order to feel better -- please simulate all this on some test server before you do in production.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial