No announcements
Found 1304745 threads
-
0 VotesMerge pull subscription reinitialize based on data changes
Note that if you have over 1000 changes there may be more than one generation between synchronizations.Answered | 1 Replies | 2335 Views | Created by Viki Vig - Monday, October 1, 2012 3:03 PM | Last reply by Hilary Cotter - Monday, October 1, 2012 5:37 PM
-
1 Votes
SQL2005 SP3 Error Merge Pull subscription
Can you disable metadata cleanup in your agent by adding the -MetadataRetentionCleanup to 0 and then after all the data is uploaded try to reinitialize.Answered | 3 Replies | 4303 Views | Created by Norman Armas - Thursday, May 31, 2012 7:02 PM | Last reply by Hilary Cotter - Friday, June 1, 2012 1:42 PM -
0 Votes
Permissions for Merge Repl Pull Subscription
SQL 2014 Standard Merge replication problem.Answered | 1 Replies | 853 Views | Created by TomInNC - Friday, August 12, 2016 3:29 PM | Last reply by Martin.Cairney - Monday, August 15, 2016 1:40 AM -
0 Votes
Transactional replication, change from push subscription to PUll
The best and clean way is to drop the Push Subscription and to create the new Pull Subscription.Answered | 1 Replies | 1293 Views | Created by '''HuuM''' - Tuesday, October 28, 2014 4:28 PM | Last reply by Ashwin Menon - Wednesday, October 29, 2014 10:37 AM -
0 Votes
Difference between running a snapshot agent and full reinitialize of subscriptions
For merge replication with unfiltered subscriptions a new snapshot will only snapshot new articles.Answered | 1 Replies | 1056 Views | Created by MJ2012 - Monday, June 20, 2016 5:19 PM | Last reply by Hilary Cotter - Monday, June 20, 2016 6:53 PM -
0 Votes
Replication monitor issue, anonymous pull subscriptions to merge publication for web synchronization
In either of the above cases, you need to execute the sp_dropmergesubscription procedure on the publisher to remove pull subscription to a ...Answered | 5 Replies | 9209 Views | Created by Alexander Yarushin - Thursday, May 8, 2008 4:23 PM | Last reply by Gurwinderjit MSFT - Monday, December 14, 2009 8:17 PM -
1 Votes
Reinitialization in replication
There is also an alert Replication: Subscriber has failed data validation that can be configured with a response to execute the job Reinitialize subscriptions ...Answered | 6 Replies | 1998 Views | Created by sqlproddba - Tuesday, August 5, 2014 12:58 PM | Last reply by Brandon Williams - Friday, August 8, 2014 7:50 PM -
0 Votes
Push and Pull Subscriptions
Hi Pavan, You can create a new pull subscription on the same publication after creating a push subscription.Answered | 2 Replies | 1073 Views | Created by Pavan uppala - Saturday, February 28, 2015 11:11 PM | Last reply by Pavan uppala - Saturday, March 14, 2015 7:23 AM -
0 Votes
Merge Replication - Pull From Client
Update: I can run Merge Agent via Task Scheduler to sync pull merge subscription on SQL Server 2008 R2 Express, check my another ...Answered | 6 Replies | 7485 Views | Created by BenHamiin - Wednesday, April 6, 2011 3:44 AM | Last reply by Replfun - Wednesday, April 13, 2011 2:07 AM -
2 Votes
Does a Push Subscription effect other Pull Subscriptions??
Technically , there will be no problem ....But Since it will be a push subscription there will be an addiional overhead on Distributor ( which is not in the case of ...Answered | 5 Replies | 8189 Views | Created by Ashish Gilhotra - Thursday, April 21, 2011 6:17 AM | Last reply by Abhay_78 - Saturday, April 23, 2011 9:40 AM -
0 Votes
The merge process could not clean up the subscription
Note: 1 - the replication process stopped after replicate DB schema(tables) then we get this error 2 - i tried replicate a two tables from ...Answered | 5 Replies | 6707 Views | Created by aabdan - Friday, December 7, 2012 10:09 PM | Last reply by aabdan - Sunday, December 9, 2012 2:48 AM -
1 Votes
Initialise Subscription from Backup for Pull subscription
Hi Thomas, Yes, you can initialize a pull subscription from a backup.Answered | 6 Replies | 2021 Views | Created by Thomas Rhea - Tuesday, January 28, 2014 1:06 PM | Last reply by Brandon Williams - Wednesday, January 29, 2014 5:24 PM -
0 Votes
Programmatically changing a merge replication agent job
You can't reinitialize an upload only subscription without changing it to being bi-directional.Answered | 8 Replies | 7118 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
Problem with creation of pull subscription
Go ahead and delete the subscriber using GUI and create a pull subscription again from GUI instead of scripts.Answered | 3 Replies | 7656 Views | Created by andsm - Thursday, October 6, 2011 5:42 PM | Last reply by Shailesh_23 - Friday, September 8, 2017 9:51 AM -
3 Votes
The subscription(s) have been marked inactive and must be reinitialized
You can always SQL, follow the link below you will get the some thing like this, so before sync you have upload the unsync data and for that you have to change the ...Answered | 10 Replies | 60145 Views | Created by pai_prasad - Monday, December 15, 2008 6:55 PM | Last reply by Sonia Sharma 7381 - Thursday, December 4, 2014 7:17 AM -
0 Votes
Adding New Articles (Tables/Views) to Existing Merge Publication & Reinitialization
Adding articles to existing publications does not require reinitialization.Answered | 1 Replies | 1087 Views | Created by 2012S4 - Thursday, November 21, 2013 5:51 AM | Last reply by Brandon Williams - Thursday, November 21, 2013 6:37 AM -
0 Votes
Reinitialize Subscriber Question
It will not reinitialize the subscription for the subscriber in domain B.Answered | 2 Replies | 953 Views | Created by mkal55 - Wednesday, January 8, 2014 2:24 PM | Last reply by mkal55 - Thursday, January 9, 2014 1:58 PM -
0 Votes
Reinitializing only new tables in transactional replication
are we talking merge replication or transactional?Answered | 6 Replies | 8549 Views | Created by Prasant Pardesh - Saturday, October 11, 2014 8:24 PM | Last reply by Hilary Cotter - Tuesday, May 31, 2016 12:34 PM -
0 Votes
Subscription based on users data
Hi Prakash, Your Report must have parameter on Name so that data driven subscription query can filter the data.Answered | 1 Replies | 619 Views | Created by PrakashThandra - Saturday, April 2, 2016 9:26 AM | Last reply by Prasad msbitips - Saturday, April 2, 2016 2:49 PM -
1 Votes
Merge replication metadata deletion error MSSQL_REPL-2147199402
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the subscriber for changes not yet sent to the ...Answered | 10 Replies | 11131 Views | Created by Matt Lyons [ML] - Tuesday, April 12, 2011 3:00 PM | Last reply by JamesSmiths - Monday, October 12, 2015 5:12 PM - Items 1 to 20 of 1304745 Next ›
No announcements
