Database Reference
In-Depth Information
10. On the WITNESS instance, execute the following (see the next screenshot):
CREATE ENDPOINTMirroring
STATE=STARTED
AS TCP (LISTENER_PORT=5024,
FOR DATABASE_MIRRORING (ROLE=WITNESS)
It is possible to SUSPEND a mirroring session and later RESUME it. If the mirroring is
suspended for an extended period of time then, ensure sufficient disk space is available on
the drive where the transaction log file is located.
The WITNESS is an essential instance of SQL Server that enables the mirror server in a high-
safety mode session to recognize whether to initiate automatic failover, when no user data is
stored on the witness server.
To enable Database Mirroring between two dedicated network adapters that is, between NIC2
of the Principle and NIC2 of the Mirror, we need to have a Full Qualified Domain Name(FQDN)
for each of those instances. To perform this, complete the following steps:
1. Add the corresponding FQDN of NIC2 on the host file of each server.
2. The host file is located in the
C:\Windows\System32\drivers\etc
folder.
Append the IP address of the corresponding instance and FQDN at the end of the
host file:
161.19.70.02 DBM-MIRO.DBIA-SSQA.com
161.19.70.04 DBM-PRIM.DBIA-SSQA.com
Search WWH ::
Custom Search