![]() ![]() The partner that is unable to read a page requests a fresh copy from the other partner. For more information, see Operating Modes, later in this topic.Ī database mirroring partner running on SQL Server 2008 Enterprise or later versions automatically tries to resolve certain types of errors that prevent reading a data page. For more information, see Role Switching, later in this topic.ĭatabase mirroring provides complete or almost complete redundancy of the data, depending on whether the operating mode is high-safety or high-performance. ![]() In the other operating modes, the database administrator has the alternative of forcing service (with possible data loss) to the standby copy of the database. ![]() In the event of a disaster, in high-safety mode with automatic failover, failover quickly brings the standby copy of the database online (without data loss). Benefits of Database Mirroringĭatabase mirroring is a simple strategy that offers the following benefits: For information about support for database mirroring, restrictions, prerequisites, recommendations for configuring partner servers, and recommendations for deploying database mirroring, see Prerequisites, Restrictions, and Recommendations for Database Mirroring.
0 Comments
Leave a Reply. |