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 SQL Server 2008 Clustering on Windows Server 2008

    In this webcast we are going to install SQL Server 2008 Clustering on Windows server 2008. Ive already made my both the nodes clustered with Windows server 2008 and the details are below.

  • Installing MSDTC as Cluster Aware Service

    This is my first webcast for 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…