Categories
High Availability

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:

Categories
High Availability

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

Categories
High Availability

Comparison between Mirroring VS Log shipping and Mirroring VS Clustering

Database Mirroring Vs Clustering

Categories
High Availability

Database Mirroring Role Change

Role Change in Mirroring :

Database mirroring failover is an issue that can be considered from the standpoint of the database mirroring servers or the application. From the standpoint of the database mirroring servers, failover is the conversion of the mirror server into a principal server and the use of the newly recovered database as the principal database in the session. The failover may be automatic, manual, or forced.

Categories
High Availability

Advantages & Disadvantages of Database Mirroring

Advantages Database Mirroring: