Adding Article to Transactional Replication Publisher without Snapshot Re-initialisation

Add article to Transactional Replication without Snapshot Re-initialisation To add a new article to a publisher efficiently without reinitializing whole replication but running the below scripts/procedure can be done without whole snapshot to be run again. This method only snapshots the new article added to the publisher. The Steps needs to be followed in same…

SQL Server Transparent Data Encryption

SQL Server 2008 Transparent Data Encryption (TDE) A secure Environment can be built by designing a secure system, encrypting confidential assets, and building a firewall around the database servers. However, in a scenario where the physical media (such as drives or backup tapes) are stolen, a malicious party can just restore or attach the database…

Administration of Transactional Replication

Administration of Transactional Replication There are 3 types of Replication Types in SQL Server: 1. Snapshot Replication 2. Transactional Replication 3. Merge Replication Replication of data can be configured between same server or can be different servers connected by Network. SQL Server replication uses a publisher, distributor and subscriber for replication to work . Publisher…

SQL Server Architecture