SQL 2005 Replication

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by cveselka on 09 February 2010

We have setup Merge replication to allow to different DB’s that are being updated seperately by 2 different companies. The Merge process is working fine. We had a problem last week were the SnapShot was applied on the subscriber side and of course it overwrote data on the subscriber that had been applied. The snapshot agent was setup to run during SQL
Agent Startup but I changed it to run on Sundays at 1 PM. The merge agent on the Subscriber side runs every 5 minutes so I expected the Merge Agent to pull the snapshot around 1:15 PM on Sunday. It did not pull it and still hasn’t. I guess my question is, When does the Merge agent pull down a snapshot? I would like it to be scheduled during the off hours. We lost a lot of data last week that had to be entered because of this.

Learnmore Microsoft SQL Server databases hereShould you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting