MS SQL Server – Database Mirroring

Types of mirroring:

High availability:

–        Synchronized writes on principal and mirror

–        Automated failover

–        Requires witness server

High Protection:

–        Synchronized writes on principal and mirror

–        Manual failover

–        No witness server required

High performance:

–        Not synchronized (assumed writes will be completed on both principal and mirror)

–        Forced failover only

–        Witness not required

For more information, go to following link http://www.slideshare.net/himickey/database-mirroring-setup