Category: High Availability

  • How to Move mirrored database files

    The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have the following scenario:

  • Schema changes in SQL Server 2005 Transactional Replication

    Schema changes will be replicated by default. I am adding a column named street to the table Address using the below command,

  • How to Configure Peer to Peer replication – GUI

    This article takes you with simple steps in configuring peer-to-peer replication. P2P replication is new to SQL server 2005 and though looks like complex in theory its one of the easiest to configure and maintain on long run. The following steps take you through the configuration process.

  • Testing Cluster Configuration

    Most people never like to test what they can done. Assuming that things have been done perfectly which results in a situtation of panic sometimes. So i thought that i could let you all know the steps to check after completing a cluster configuration.

  • Getting Information on SQL Server Cluster

    SQL Server 2005 arguably gives the best resources to see if the instance is clustered or not. And if so, what are the properties of the cluster. The DMVs that are related to the Cluster can be used for this. These DMVs are very useful for a new DBA joining a company who can easily…