May 22, 2013 at 8:37 am
Hello all,
I have a couple of issues while trying to implement snapshot replication. Basically, I just want a nightly copy of a production database on server 1 to a reporting database on server 2. Seems simple enough, right?
First, every time I go into the article properties, the "Action if name is in use" option is always set to "Drop existing object and create a new one." If I change it, hit "OK" and exit out, then come back in, it will still show as "Drop existing object and create a new one."
Does it just show that as the first option, regardless of what is actually being used? (I've tried setting it to "Delete data. If article has a row filter, delete only data that matches the filter."
Second, the scheduled replication processes seems to be working fine. The snapshot gets generated fine (without any errors), and then (later) the distribution job runs fine (without any errors).
However, the data doesn't change on the reporting database.
Can someone point me to some common reasons that this might be happening? Perhaps some options or settings that I have overlooked?
Thanks.
May 24, 2013 at 7:42 am
I'll bump this a single time, hoping that someone has some info... anything?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply