Skip to main content
Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
Database Mirroring on SQL Server 2008 R2

Database Mirroring on SQL Server 2008 R2

Views: 1099
#
#
#
#
#
About This Video

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)

Download the slides.



Published Date: June 30, 2011
Presented By: Anthony de Bruyn

Downloads

Video: WMV | MP4 | WMV (ZIP) | PSP
Audio: WMA | MP3

Related Videos

How Many Nines Do We Need? Introducing SQL Server AlwaysOn Views:321 How Many Nines Do We Need? Introducing SQL Server AlwaysOn
Upgrading to SQL Server 2008 R2 and SQL Server Denali Views:104 Upgrading to SQL Server 2008 R2 and SQL Server Denali
Database Schema Management & Deployment using SQL Server Data Tools (SSDT) Views:517 Database Schema Management & Deployment using SQL Server Data Tools (SSDT)
TechDays 2010: Upgrading the database engine ...done right Views:23 TechDays 2010: Upgrading the database engine ...done right
SQL Server Day: Hyper-SQL, Running SQL Server in a virtual environment Views:77 SQL Server Day: Hyper-SQL, Running SQL Server in a virtual environment
SQL Server Day: Is it a Bird? Is it a Plane? No! It’s your database in the cloud! Views:34 SQL Server Day: Is it a Bird? Is it a Plane? No! It’s your database in the cloud!

© 2013 Microsoft