Database Mirroring on SQL Server 2008 R2
Database mirroring was introduced since Microsoft SQL Server 2005. It can be used to design high-availability and high-performance solutions for database redundancy. It is designed to maintain a hot standby server with a transitionally consistent copy of the database. Mirroring is cost-effective, speedy, requires no special hardware, and ensures transactional consistency. This live meeting will describe the database mirroring components, the different modes of database mirroring, failure types, failure scenarios, how it is different from other technologies and client redirection. Also a demo on how to setup databases mirroring with GUI and T-SQL will be shown.
Speaker: Pieter Vanhove (Kohera)
Published Date: June 30, 2011
Presented By: Anthony de Bruyn
Tags: TechNet Edge , Zune , iPod , Anthony de Bruyn , NL-BE , FR-BE , Belux , SQL Server 2008 R2 , Database Mirroring , Screencasts , Media