Systems and methods of backup and recovery of journaling systems

A backup and restoration system for a transactional log based journaling application having a database comprising

• a transactional log backup and restore process executing on one or more computing devices, wherein the transactional log backup and restore process selects a restore type that is initiated based on a selected point in time and using a first set of binary difference files (DIFF) for a first restore process or selecting a restore type that is initiated based on a fault or other point of failure and using a second set of DIFF for a second restore process;
• an archive stored in non-transitory computer readable memory at a server;
• a file tracker driver in electrical communication with and responsive to communication signals from the transactional backup process, wherein the file tracker driver is programmed to track changes in the database following a backup;
• and
• a binary difference file generator at the server and in electronic communication with the archive and responsive to instructions from the transactional log backup process, wherein the binary difference file generator creates one DIFF of the database from one or more transactional logs of the database and the changes tracked by the file tracker driver, wherein the database runs on a first computing device, wherein the one or more DIFF comprise block by block differences relative to the database;
• wherein the transactional log backup and restore process is configured to reduce processing load on the first computing device by restoring one or more transactions to the database using the one or more DIFF instead of the transactional logs, wherein a plurality of DIFF is used to replay a virtualized database from prior backups and accumulated DIFF files to generate a restored database wherein the processing load of the first computing device is reduced by deprioritizing the replaying of the one or more transactional logs such that the replaying utilizes only unused resources of the first computing device.

A backup and restoration system comprising

• a database comprising n transactional logs;
• a file tracker driver, wherein the file tracker driver is programmed to track changes in the database following a backup;
• a server comprising one or more processors, an archive running on the one or more processors, a binary difference file generator running on the one or more processors, wherein the binary difference file generator is configured to generate, using the file tracker driver, one or more binary difference files (DIFF) of the database from one or more of the n transactional log;
• and
• a transactional log backup and restore process executing on one or more computing devices, wherein the transactional log backup and restore process selects a restore type that is initiated based on a selected point in time and using a first set of binary difference files (DIFF) for a first restore process or selecting a restore type that is initiated based on a fault or other point of failure and using a second set of DIFF for a second restore process;
• wherein the transactional log backup and restore process is configured to reduce processing load on the one or more computing devices by restoring one or more transactions to the database using the one or more DIFF instead of the transactional logs wherein the processing load of the first computing device is reduced by deprioritizing the replaying of the one or more transactional logs such that the replaying utilizes only unused resources of one or more computing devices.