Both are High Availability features and provides automatic failover in SQL Server environment.
Clustering provides high availability at Instance Level. If one instance fails, the other instance will take care of the operation.
Mirroring provides high availability at Database Level.High-availability database mirroring involves three server instances: a principal, a mirror, and a witness. The witness server enables SQL Server to automatically fail over from the principal server to the mirror server.
Clustering provides high availability at Instance Level. If one instance fails, the other instance will take care of the operation.
Mirroring provides high availability at Database Level.High-availability database mirroring involves three server instances: a principal, a mirror, and a witness. The witness server enables SQL Server to automatically fail over from the principal server to the mirror server.
No comments:
Post a Comment