DB mirroring with SQL Server 2005: Standard vs. Enterprise
On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow automatic failover, Enterprise edition was required.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 30, 2010 10:21 PM
UPDATED:
March 31, 2010 3:46 AM
RELATED QUESTIONS
- Estimated cost for upgrade from SQL Server 2005 SE to SQL Server 2005 EE
- Differences between SQL Server 2005 Standard Edition and Enterprise Edition?
- Differences between SQL Server 2005 and SQL Server Express
- Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
- SQL Server 2005 multi-instance cluster
Answer Wiki:
To use automatic failover you need to be in high safety mode which requires Enterprise, making automatic failover an EE only feature.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
