SQL Server Video

Submit Video
Home » Videos » SQL Server

SQL Server 2008 Demo Database Mirroring

  Shared By: baghul      Date: Feb 03      Category: SQL Server     
www.learningsqlserver2008.com In this training demo on SQL server 2008, we cover one of the high availability topics database mirroring. Database mirroring has been around since SQL server 2005 is an excellent choice for high availability at a nominal cost. In this training demo on ms SQL 2008 server, we cover topics like Principal, Mirror and Witness servers. We over the requirements for database mirroring which you can think of as real time log shipping. You can use 3 modes which are high performance, high safety and high safety with automatic failover in SQL Server 2008. In order for database mirroring to function you need to have the database in full recovery model with Filestream option disabled. You can take a database and log backup of the Principal database and then restore it with norecovery option on the Mirror Server.

Didn't find what you were looking for? Find more on SQL Server 2008 Demo Database Mirroring Or get search suggestion and latest updates.


Related Videos