Browse by Tags

SQL Server 2005 - specific roles for replication agents

Published 22 February 8 2:10 PM | SSQA.net

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...

Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions

SQL Server replication FAQ and important measures to consider when replication performance is sufferred

Published 7 February 8 9:41 AM | SSQA.net

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including...

Filed under: sql server, performance, replication, snapshot, best practices, agent, publisher, subscriptions, FAQ, schedule

How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

Published 11 September 7 4:3 AM | SSQA.net

Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION...

Filed under: sql server, update, replication, monitor, merge, publisher, subscriptions