Content deleted Content added
Xose.vazquez (talk | contribs) |
|||
Line 227:
Service Pack 1 (SP1) of SQL Server 2005 introduced Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level.<ref name="database mirroring">{{ cite web | url = http://support.microsoft.com/kb/907741 | title = Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005 | publisher = Support.microsoft.com | date = 2007-11-20 | accessdate = 2011-09-04 }}</ref> Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).<ref name="Automatic Failover">{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms189590.aspx | title = Automatic Failover | publisher = Msdn.microsoft.com | accessdate = 2011-09-04 }}</ref> Database Mirroring was included in the first release of SQL Server 2005 for evaluation purposes only. Prior to SP1, it was not enabled by default, and was not supported by Microsoft.{{citation needed|date=June 2015}}
Mainstream support for SQL Server 2005 ended on April 12, 2011, and Extended support for SQL Server 2005 ended on April 12, 2016.
=== SQL Server 2008 ===
| |||