Category: High Availability
-
Replication Components and Agents
Replication Components SQL 2005 replication is based on the Publish and Subscribe metaphor. Let us look at each of the individual components in detail.
-
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
-
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…
-
Advantages & Disadvantages of Database Mirroring
Advantages Database Mirroring:
-
Ten Steps to configure Log Shipping
I have used 3 instances to configure log shipping and they are as follows, Deepak—>Primary DeepakSansu—>Secondary DeepakTest—>Monitor