Merge replication - Generate script for pending changes at subscriber
May 10, 2016 · Many times sql tell me reinitialize without uploading the pending changes. I need to generate the scripts on the subscriber because the connection is to slow and difficulty to transfer the …
SQL merge replications fails only over VPN
Sep 1, 2014 · - SQL replication is working well in the local Area Network. - All Firewall Profiles are equaly configuired fpr replication. - VPN client can Ping SQL Server. - SQL Server can Ping VPN …
DDL Still Replicates Even With DDL Replication Off (@replicate_ddl = 0).
Nov 19, 2008 · Set up transactional replication of one small test table. Replication is working fine. Set @replicate_ddl = 0 with sp_changepublication. I manually verify the setting (using the GUI) before …
Changed the password of distributor_admin account manually and …
Jul 29, 2013 · Do not change the password for the distributor_admin manually. Always use the sp_changedistributor_password stored procedure, or the Distributor Properties or Update Replication …
how to turn the sync with backup option on distribution database ...
Nov 26, 2012 · I have the transactional replication enabled for the reporting purpose.I need to plan for the disaster recovery also.I came across the strategy for backing up the distribution database.Can …
The merge process was unable to deliver the snapshot to the Subscriber.
Dec 15, 2009 · I'm tring to setup merge replication between SQL Server Standard Edition and SQL Server Express Edition.
Local subscriptions is empty when i move databases with replication ...
May 28, 2015 · after a lot of efforts I've moved databases with master, msdb to new server and execute replication configuration script which I was generated in old server but the 'Local subscriptions' is …
Merge replication fails on executing query - social.msdn.microsoft.com
Jul 30, 2012 · My merge replication was working fine this morning. Since an hour or 2 ago, my synchronisation status windows keeps showing this message: Thread id 3108 will wait for 15 second …
How do you calculate the space required for snapshot
Sep 6, 2016 · There is no way your snapshot should be this large. For snapshots this large you should be using the initialize from backup option.
replication error skipping file because it has already been delivered
May 7, 2014 · There's a reason replication is generating that message and it has to do with another problem while attempting to apply your snapshot. I have the same problem occasionally because …