Browse by Tags

Replication and Database Mirroring - things to take care and best practices to administer the environment

Published 15 December 8 5:37 AM | SqlServer-QA.net

Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...

Filed under: sql server, high availability, replication, monitor, maintenance, database mirroring, publisher, failover, subscriptions, setup

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