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… Continue reading SQL 2005 Transaction Replication
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:
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:
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.
I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak —> Principal DeepakSansu —> Mirror DeepakTest —> Monitor