Tag: high availability
-
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…
-
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:
-
Configuring Peer-to-Peer replication using T-SQL
This article brings you the easiest way to configure P2P replication using TSQL. Also I assume that the database has been initialized in all nodes participating in the replication. 1. Configure Distributor:
-
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.
-
How to configure Database Mirroring
I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak —> Principal DeepakSansu —> Mirror DeepakTest —> Monitor