Share this PostAnurag Sharma | Microsoft SQL Server Escalation Services Background In many cases customer often have large databases published and creating a snapshot of such large database is always a pain. And, even when published databases are of manageable size, a slow or unreliable network link can further complicate the issue. From SQL Server
Read More »
Share this PostWindows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version. The x64
Read More »
Share this PostJosé Moreira Neto | Microsoft SQL Server Escalation Services Particularities of Merge Anonymous Subscribers In Merge Replication, anonymous subscriptions are required if you want to create a subscription without registering the subscription at the Publisher. This is necessary for cases in which you cannot establish a SQL Server connection to the Publisher during
Read More »
Share this PostI recently got a customer call where the SQL 2008 Snapshot Agent appeared to hang when started from SSMS. As you can see, pop-up status window shows “Starting agent”. So, looks like its running, but it stays this way forever. Replication Monitor also shows as “Running”. If I double-click the I can zoom
Read More »
Share this PostSometimes MS SQL Replication developers use similar names for similar meaning but which can have very different results. These settings both specify alternate location for the Snapshot files, however, one is set at the publication and one at an individual subscriber. alt_snapshot_folder The alt_snapshot_folder parameter is set at the Publisher for ALL subscribers.
Read More »