Tag: mirroring
-
How to Move mirrored database files
The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have the following scenario:
-
How to configure Database Mirroring
I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak —> Principal DeepakSansu —> Mirror DeepakTest —> Monitor
-
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…
-
Comparison between Mirroring VS Log shipping and Mirroring VS Clustering
Database Mirroring Vs Clustering