Day: January 11, 2006

SQL Server 2005 – Configuring Replication In this tutorial you will learn about SQL Server 2005 – Configuring Replication – New Types of Replication, Peer to Peer Transactional Replication, HTTP Replication, Configuring Replication Configuring Replication Using RMO, Referencing the RMO and SMO libraries and Creating a Subscription Using RMO. New Types of Replication New types of replications have been introduced in SQL Server 2005. The first of these is the Heterogeneous Replication which allows the publication of data from heterogeneous subscribers such as Oracle, DB2 using relevant ODBC drive and… Read More

SQL Server 2005 Replication Enhancements In this tutorial you will learn about Overview of Replication Enhancements, User Interface Enhancements, Merge replication concurrency Enhancements, Programming changes, The Replication Monitor, Performance and Scalability Features, Pre-computed partitions, Updates to unique keys, Transactional parallelism, Download and upload only articles, Reduced contention and Managing replication. Overview of Replication Enhancements The most striking aspects of the enhancements made to SQL Server 2005 replication services are that configuration wizards have been made simpler and shorter and performance and scalability have been improved. User Interface Enhancements The first… Read More

SQL Server 2005 – Mirror Server In this tutorial you will learn about Mirror Server in SQL Server 2005 – Preparing the Principal and Mirror Server, Establishing a Mirroring Session, Establishing a Witness Server, Executing Transactions, Simulating Principal Server Failure, Restarting the Failed Server, Terminating the Mirror Session and Configuring Database Mirroring. Preparing the Principal and Mirror Server Database mirroring is easy to set up and can be made self monitoring for automatic failover in the event of the principal server being unavailable. The first step is to configure the… Read More