Viewing 10 posts - 1 through 10 (of 10 total)
Would the first option work? Just copy the entire table to the subscriber, add the article to the current publication, but do not start the snapshot agent?
October 27, 2014 at 8:00 am
Thanks for the reply.
Just to make sure I understand, I'll need to upgrade the Distributor and Subscriber to a cluster. Does that mean I will need to reinstall a...
March 21, 2014 at 9:12 am
Forgive me, but I don't understand your question. Both servers are not part of any cluster. One of the options was to migrate the data to a SAN...
March 21, 2014 at 12:00 am
The strange thing is replication works just fine on all the other tables and objects. When I add a specific table, deadlocking occurs. I just don't quite get...
January 13, 2014 at 2:22 pm
Yup, it was the log. We backed it up and it was working. Thanks.
January 13, 2014 at 8:16 am
David, never mind. I looked through the system replication tables and tried to piece them together to get what I needed. I think this query did it:
select e.id,...
December 23, 2013 at 1:44 pm
David, on a similar topic, is there a way I can find out the articles that failed during synchronization? I know I can check the error logs but it...
December 23, 2013 at 1:30 pm
Correct. I ended up going another route. Rather than creating a publication for each object type, I did the first method instead where I created one publication for...
December 16, 2013 at 7:08 am
Thanks for your reply David.
If a procedure requires a function, I am also replicating that function. However, if the procedure is replicated first, it will error out since the...
December 13, 2013 at 6:56 am
Thanks! This worked for me too. Was spinning my wheels all morning trying to figure this one out. I knew it had to be a simple trick.
November 25, 2013 at 9:20 am
Viewing 10 posts - 1 through 10 (of 10 total)