High Availability for SQL Server Replication using Database Mirroring

Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring : Highlights of this video blog :- 1. Transactional Replication Overview. 2. Database Mirroring Overview 3. Replication with Database Mirroring. 4. Mirroring the Publication database 5. Effect of the Mirroring state on the Replication Log Reader agent. 6. Mirroring…

3

Setting up Database mirroring in SQL Server 2008 using T-SQL when the database is encrypted using Transparent Data Encryption.

Consider the following Scenario, You are using SQL Server 2008 Enterprise edition RTM or higher version and you are Transparent database encryption (new feature introduce in SQL Server 2008) to encrypt the Database to be mirrored. The database encryption key has been encrypted using a server certificate and which is turn encrypted using master database…

27