No announcements
Found 1756714 threads
-
7 VotesMerge Replication Setup through WAN
With parameterized row filters - filtering with HOST_NAME() - you will need to use the -DynamicSnapshotLocation Merge Agent parameter.Answered | 7 Replies | 5185 Views | Created by KEROBIN - Monday, March 5, 2012 10:10 AM | Last reply by KEROBIN - Tuesday, April 3, 2012 1:28 PM
-
1 Votes
How well does AlwaysOn work over a WAN
Other than that ASync secondary over WAN works quite well, many people are using it.Answered | 8 Replies | 9179 Views | Created by chuckh1958 - Tuesday, July 31, 2012 2:27 PM | Last reply by BSCCO - Thursday, March 2, 2017 9:30 AM -
2 Votes
How to schedule Merge Agent
If you run the merge agent again does the change get replicated?Answered | 14 Replies | 2057 Views | Created by Mayaaa - Friday, March 22, 2013 4:38 AM | Last reply by Mayaaa - Monday, March 25, 2013 5:02 AM -
0 Votes
Merge Replication agent failed
Sometimes this error is transient and not a problem but sometimes it can cause synchronizations to fail.Answered | 4 Replies | 4360 Views | Created by SQLHunter - Wednesday, July 11, 2012 10:44 AM | Last reply by SQLHunter - Thursday, July 12, 2012 10:50 AM -
0 Votes
Improve SQL transaction speed over WAN
I'll continue to work on this problem by try to use a software named NitroPDF.. im not sure it will work but I'll try it.Answered | 4 Replies | 6102 Views | Created by Francis T. _ - Monday, August 31, 2009 12:01 AM | Last reply by - Thursday, February 4, 2016 1:51 AM -
0 Votes
Merge Agent job failure intermittently
This is a name resolution problem.Answered | 1 Replies | 2728 Views | Created by SQL .User - Wednesday, June 5, 2013 7:54 AM | Last reply by Hilary Cotter - Wednesday, June 5, 2013 12:17 PM -
0 Votes
What is the difference between merge replication setup over LAN and over VPN ?
As Hilary Mentioned You dont have to do any change since the IP will remain same even over VPN so you can easily do it - all you need to verify is the connectivity ...Answered | 2 Replies | 2479 Views | Created by Abdo Ahmed - Wednesday, November 14, 2012 7:21 AM | Last reply by Sarabpreet Singh Anand - Thursday, November 15, 2012 9:55 AM -
0 Votes
Project 2010 slow to open files over WAN
Hrishi Deshpande – Senior Consultant DeltaBahn Blog |Answered | 3 Replies | 5245 Views | Created by louiseblack007 - Monday, April 15, 2013 11:55 AM | Last reply by Mohammed Ayub B - Tuesday, July 16, 2013 4:57 AM -
0 Votes
merge agent doesn't upload again!
By setting it to 0, it will try to sync 1000 changes all at once, and if by the 999th change the network cuts out, merge agent will retry from the beginning all over again.Answered | 58 Replies | 44672 Views | Created by WII - Sunday, May 27, 2007 11:52 PM | Last reply by aomara - Sunday, December 28, 2008 11:01 AM -
0 Votes
Fox Pro - Latency over the WAN Issue
Is there a way to improve the latency of the application over the wan.Answered | 1 Replies | 5127 Views | Created by Hutchinson123 - Tuesday, August 25, 2009 6:48 PM | Last reply by Ed Price - MSFT - Friday, September 14, 2012 2:49 AM -
0 Votes
SQL merge replications fails only over VPN
Hey Folks, I planned and configured a VPN infrastructure (SSTP VPN with EAP) and now I have a problem with SQL merge replication over ...Answered | 1 Replies | 1480 Views | Created by McZalle - Friday, August 22, 2014 5:04 AM | Last reply by Hilary Cotter - Friday, August 22, 2014 12:19 PM -
0 Votes
Merge Agent fails to deliver snapshot
This problem was found and corrected; Since the subscriber machine was replaced, the server name in sys.servers was not matching the replication scripts.Answered | 1 Replies | 3195 Views | Created by Yaniv Etrogi - Wednesday, October 31, 2012 6:02 PM | Last reply by Yaniv Etrogi - Thursday, November 8, 2012 10:59 AM -
2 Votes
SQL Server Connection over WAN Link
There is no problem with slow connection :-) You might get lots of waits in the SQL side (most likly there will be lots of ASYNC_NETWORK_IO) which you can monitor ...Answered | 2 Replies | 8506 Views | Created by xSteveFx - Wednesday, March 15, 2006 11:25 PM | Last reply by Shanky_621 - Thursday, April 24, 2014 10:47 AM -
0 Votes
SQL2000 Snapshot agent - difference between Transactional and Merge
For merge replication the snapshot does not do the change tracking that transactional snapshot agents do and because of this the snapshot is only generated each ...Answered | 1 Replies | 6929 Views | Created by nonno peter lee - Tuesday, June 15, 2010 9:21 AM | Last reply by Hilary Cotter - Tuesday, June 15, 2010 12:00 PM -
0 Votes
Programmatically changing a merge replication agent job
My merge agent profile clearly has an ExchangeType set to 1 but my subscriber is still downloading changes.Answered | 8 Replies | 7027 Views | Created by Matt Lyons [ML] - Tuesday, April 12, 2011 9:44 PM | Last reply by Matt Lyons [ML] - Wednesday, April 13, 2011 10:39 PM -
0 Votes
Merge agent may fail during merge replication
I will propose this to our guys and see if they would have any problem.Answered | 4 Replies | 2724 Views | Created by JeremyParks - Friday, August 23, 2013 8:36 PM | Last reply by zcurtin608 - Monday, September 9, 2013 5:18 PM -
1 Votes
Another merge agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.
This caused some orphan merge agent processes on the publisher to remain and prevented the subscriber's merge agent from running again.Answered | 6 Replies | 11978 Views | Created by Carlos Araya - Tuesday, April 20, 2010 3:36 PM | Last reply by jendonl - Tuesday, August 31, 2010 8:22 PM -
0 Votes
Problem inizialiting a large Merge Replication
We have a Merge publication with 8 push subscribers, all connected to at 1 Gbps network LAN, so no WAN link in the middle.Answered | 3 Replies | 1149 Views | Created by Ruggiero Lauria - Tuesday, July 14, 2015 2:25 PM | Last reply by Hilary Cotter - Wednesday, July 15, 2015 4:15 PM -
0 Votes
Question about merge replication and large subscriptions
The snapshots can then be compressed and FTPd to Subscribers and applied locally using the Merge Agent -DynamicSnapshotLocation parameter.Answered | 1 Replies | 3741 Views | Created by DanyM - Wednesday, April 25, 2012 1:29 PM | Last reply by Brandon Williams - Thursday, April 26, 2012 4:17 AM -
0 Votes
Using Project 2010 Pro ( not on server) over a Corporate WAN - VERY Slow
Seperate the problem: problem 1. how can we as a team use Project to help us manage the project?Answered | 6 Replies | 8262 Views | Created by Mark Jossa - Wednesday, October 19, 2011 8:18 PM | Last reply by Andrew Lavinsky - Thursday, October 20, 2011 11:50 AM - Items 1 to 20 of 1756714 Next ›
No announcements
