A Look at Database Mirroring

Tuesday Jul 17th 2007 by DatabaseJournal.com Staff

One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology.

[From SQL Server Central]

Database Mirroring is a major new technology for achieving high availability in SQL Server 2005. Database Mirroring operates at a database level and is configured on a database-by-database basis. The primary goal of database mirroring is to increase data availability and allow failover in case a server hosting the database becomes unavailable. So including Database Mirroring now we have 4 High Availability in SQL Server 2005 (1) Clustering (2) Log Shipping (3) Replication (Transactional) (4)Mirroring. I can say that Database Mirroring is Log Shipping with automatic failover per database & Clustering on database level without single point of failure without shared disk.

The article continues at http://www.sqlservercentral.com/columnists/jDave/3046.asp

Mobile Site | Full Site