SQL-Articles

Category: High Availability

  • Renaming a Failover Clustering Instance of SQL Server

    Can you rename the SQL virtual name in a Cluster? The answer for this in SQL Server 2005 is obviously Yes. New to SQL Server 2005 is the ability to rename a clustered instance of SQL Server without having to uninstall and reinstall it.

  • Transactional Replication

    This article teaches you how to set up transactional replication using wizards and scripts. In most cases, youll set up the initial publication and subscribers using wizards; however, if you need to apply the same publication in multiple environments, youll appreciate the option of applying the scripts as opposed to going through wizards time and…

  • Transactional Replication – Configure Subscriber

    Unlike previous versions, of SQL Server 2005 allows you to use the same wizard to create either pull or push subscriptions. Perform the below steps to Configure Subscriber

  • Transactional Replication – Configure Publication

    Once youve configured a distributor, youre ready to create publications. Perform the below steps as follows, Step1 : Connect to an instance (Sansu) of SQL Server by using the SQL Server Management Studio (SSMS), navigate to the “replication” folder then local publications folder, right-click this folder, and select New Publication. This invokes the new publication…

  • Transactional Replication – Configuring Distributor

    Lets Discuss the steps to Configure Distributor in detail. In this article I am using the Server SansuTest as the Distributor. The Distributor is configured from SSMS as follows :