Multiple choice technology databases

Which edition of SQL server supports Asynchronous mirroring.

  1. Workgroup

  2. Express

  3. Standard

  4. Enterprise
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL Server Enterprise Edition provides full high availability features, including asynchronous database mirroring with automatic failover using a witness server. Standard Edition only supports synchronous mirroring without a witness, while Workgroup and Express have very limited mirroring capabilities.

Keep practicing — related questions