Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dkimbrell
Starting Member
9 Posts |
 Posted - 2012-03-12 : 21:26:25
|
| We have multiple laptops setup for merge replication with our SQL Server 2008 server. Whenever I add or remove a table or view on the server and add it as an article for replication, I need to create a new snapshot. My questions is: if I create a new snapshot, and a user synchs, will that user lose all their changes since they last synched? Put another way, does a new snapshot completely overwrite all subscriptions' data?I've tried to search answers for this and have found some posts saying that this depends on my merge replication setup: whether I have it set to merge data first, and then apply snapshot, or to just apply the snapshot. If this is true, and this is a setting, where do I find it?Sorry, I'm a wanna-be database designer newbie who is in over her head unexpectedly. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-13 : 11:37:47
|
| Set UPLOAD_FIRST property, to have the changes synched before the snapshot is applied.See here for details.Should read this one too. |
 |
|
|
dkimbrell
Starting Member
9 Posts |
Posted - 2012-03-13 : 14:02:07
|
| Thanks so much, the re-initialization links really helped.When marking a subscription for re-initialization, I can see the checkbox for Uploading Changes first. But I don't see this option when simply creating a new snapshot.Since a new snapshot does not automatically trigger a full re-initialization, I'd think this option must exist somewhere else as it applies to a snapshot instead of a full re-initialize, right?Where can I find this UPLOAD_FIRST property as it applies to snapshots, both in terms of checking to see what the value is currently set to, and how to set it to a new value? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-13 : 22:06:21
|
| If you run a snapshot, you want to re-initialize the subscriber(s).If no subscribers are found that need re-initialization, snapshot will be discarded. |
|
|
|
|
|
|
|
|
Newbie question about snapshots