Category: High Availability

Steps to configure SQL server Availability Groups in DENALI

In this blog post I will drive you through configurations steps required (with GUI screens) to successfully implement SQL server’s new high availability option called “ALWAYSON” aka HADR . If you haven’t read more about Always ON or Availability groups in SQL server code named “Denali” version, here are some articles that I would recommend […]

Installing MSDTC as Cluster Aware Service

This is my first webcast for sql-articles.com. In this article we are going to discuss on Installing MSDTC as cluster aware service on Windows server 2008. We need this service as cluster aware because this is the pre-requisites when configuring SQL Server 2008.

Validating Replication Subscriber using TSQL

Last post from me on SQL Server replication was on How to validate subscribers in SQL Server Replication. This article shows how the same can be done using TSQL. sp_publication_validation: This system stored procedure does a validation for each and all articles in the specified publication in transactional replication. This stored procedure is executed against […]

SQL 2005 Transaction Replication

I have an existing publication with 10 articles configured for Transactional replication. The replication is running fine. Now I wish to add another table (article) to this publication. My requirement is to ensure that I dont need to generate a snapshot of all the articles being published, if I add a single article only that […]