Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.. GeoPITS brings you the comprehensive details of Database mirroring's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes (Witness Only) | Yes (Witness Only) | Yes (Witness Only) |
| Version v2017 | Yes | Yes Full safety only | Witness only | Witness only | Witness only |
| Version v2016 | Yes | Yes Full safety only | Witness only | Witness only | Witness only |
| Version v2014 | Yes | Yes | Yes (Witness Only) | Yes (Witness Only) | |
| Version v2012 | Safety Full Only | Witness only | Witness only | Witness only |
Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
You can find more details about this version here
Back to all features