Cold Backup (What is Cold Backup or Offline Backup?)
A cold backup is a database backup in general. Actually outside the database; It is the name given to stopping and backing up the used data (including computer image, system configuration, etc.) system. For example; When you want to back up your running outlook pst, some applications; “Please close your Outlook application for this operation.” The reason it says is because it can only take Cold Backup.
Cold Backup backups are made when the database is offline and inaccessible to users "Offline Backup" It's called in. Here, database operations are completely stopped, and then backup is started. As long as the backup continues, no action can be taken. Cold backup is mostly applied at the beginning and/or end of the day. In this way, minimum labor loss is targeted.
This situation has some advantages;
During the backup; the process will be faster since no data can be added/modified and edited. Since cold backups will be kept separately, they will not be affected by attacks such as viruses and power outages.
During the backup; Hardware resource consumption may be less as the device switches to offline mode. Because only backup will be taken. During this period, the system may not consume power to other resources (control of services, update checking, etc.).
Since the system must be completely stopped or shut down while taking a backup, this process may not be possible in systems where continuity is required.
Cold backup (Cold Backup) can be quite suitable for devices with certain working hours. This way, you will have more consistent backups on hand.
It may not be correct to take the cold backup to another disk in the server, in case of any electrical failure or short circuit that may occur on this server, the other disk may become unusable. To prevent this situation, portable disk, backup to a different server/media/media or cloud applications (Acronis Cyber Protect Cloud etc.) is preferable.
Disaster Recovery with cold backup (Disaster Recovery) scenario combination may result in the recovery of the entire infrastructure: imagine a cold backup of your running system in the evening, in case the server does not turn on when you come in the morning, in the Disaster Recovery Centers (Disaster Recovery Center) with your server, you can open your cold backup and ensure that your company's business continues from where it left off.
Finally, Cold backups are very easy to manage. Writing the process for the backup job will be simpler and faster than other backup types.
Well Hot (hot) and Warm (warm) What is Backup?
As you can guess from the name, hot backup is the feature of taking backup while the database and/or server is running. In this way, it is aimed to take backups without interrupting the system.
We can explain this better as follows; Imagine that your two servers send a database copy to each other at intervals that you specify, in most cases, both servers are always standing and if any damage occurs to the original server where the data is kept, the server with the Hot backup replaces it and the work is considered to have continued almost non-stop.
With hot backup, in some cases, it can cause the database to be inconsistent because it may be writing data at the time. It can also be slow compared to Cold Bakcup because it is responsible for both responding to queries and ensuring that file is backed up.
Warm backup, on the other hand, is very similar to hot backup, generally the servers where Warm backup is kept are opened at the time of backup, test or failure. These servers are more mirroring (mirroring) or replication (replication) are used for.