Tag: mirroring
-
Types and Operating Modes in Mirroring
Mirroring offers two methods for exchanging data, lets discuss each one in detail.The two are * Synchronous mirroring * Asynchronous mirroring
-
How can I bring mirror database online after principal server is down ?
Safety FULL with Witness : Well the answer for this ‘depends on the mode in which mirroring is configured’. If mirroring is configured in High Availability mode (Full safety) then we don’t need to worry about failover as the mirror server will form a quorum with witness and will initiate an automatic failover. The safety…
-
Introduction to Database Mirroring
Overview of Mirroring: Mirroring is mainly implemented for increasing the database availability. Similar to log shipping mirroring is also implemented on per database basis. Database mirroring maintains two copies of a single database that must reside on different instances of SQL Server Database Engine (server instances). Typically, these server instances reside on computers in different…