How Do I: Set up Database Mirroring??
Database mirroring is a feature of SQL Server that allows an administrator to create a copy of the database that is always up to date. If the principal server fails or needs to be taken offline for maintenance the mirror server can be quickly set up to take on the workload. Mirroring provides high availability for the databases. In this podcast speaker explains how to use T-SQL commands to set up database mirroring between two servers. Follow along with these easy steps to create a database mirror to help protect the mission critical data.