Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

SQL Server 2005 Mirroring – Tutorial

Posted by Oded Raz on Feb 6th, 2010 and filed under High Availability, SQL Server, SQL Server - Latest Articles, Videos. You can follow any responses to this entry through the RSS 2.0. You can leave a response or trackback to this entry

SQL Server 2005 provides a set of high availability methods that the users can use to achieve fault tolerance and to prevent server outages and data loss. The selection of the high availability method depends on various factors. Some DBAs need the servers to be available 24/7, while others can afford an outage of a couple of hours. Cost also plays a role in the selection. For example, Clustering is an expensive high availability method when compared to Database Mirroring, but it allows the user to failover immediately.

Leave a Reply

Log in / Advanced NewsPaper by Gabfire Themes