Database replication
Database replication consists of transferring a complete copy of the IPFX Server's database onto the Failover Server. This process is performed nightly by an application called BackupUtil.exe.
BackupUtil.exe obtains a copy of the IPFX Server's database in the following manner:
A command is issued to the IPFX Server, instructing it to back up the database to a file:
BACKUP DATABASE [CTSERVER]
TO DISK = N'C:\VM\DB\MSSQL$CTSERVER\DATA\AKLMATRIX_CTSERVER.bak'
WITH INIT ,
NOUNLOAD ,
Name = N'AKLMATRIX_CTSERVER' ,
SKIP ,
STATS = 10 ,
Description = N'AKLMATRIX_CTSERVER',
NOFORMAT
This file is copied to the Failover Server:
FILECOPY \\AKLMATRIX\C$\VM\DB\AKLMATRIX_CTSERVER.BAK TO C:\SERVERS\AKLMATRIX\VM\DB\MELDEVTEST_CTSERVER.BAK
The file is restored to a database on the Failover Server:
RESTORE DATABASE AKLMATRIX_CTSERVER
From DISK = N' C:\SERVERS\AKLMATRIX\VM\DB\MELDEVTEST_CTSERVER.BAK '
WITH
MOVE 'CTSERVER' TO N' C:\SERVERS\AKLMATRIX\VM\DB\AKLMATRIX_CTSERVER.MDF,
MOVE 'CTSERVER_log' TO N' C:\SERVERS\AKLMATRIX\VM\DB\ AKLMATRIX_CTSERVER.LDF'
A Hot Failover Server also uses a second method of database replication. In addition to the nightly backup described above, the Hot Failover Server picks up real-time changes made to the IPFX Server throughout the day. The Hot Failover Server does this via a network connection to the Message Server on the live IPFX Server. When changes are made to the live database, they are broadcast out via the Message Server. The Hot Failover Server receives this change and updates the corresponding Failover database accordingly.