![]() The following table explains the different types of backups used for SAP HANA databases and how often they're used: Backup typeĪ full database backup backs up the entire database. You can't configure a full backup and a differential backup on the same day.Ī log backup enables point-in-time restoration up to a specific second.Īt most, you can configure transactional log backups every 15 minutes. It captures only the data that's changed since the full backup.Īt most, you can trigger one differential backup per day. You can choose to make a full backup on a daily or weekly interval.Ī differential backup is based on the most recent, previous full-data backup. ![]() A full backup also contains enough logs to recover that data.Īt most, you can trigger one full backup per day. It contains all the data in a specific database or in a set of filegroups or files. The following table explains the different types of backups used for SQL Server databases and how often they're used: Backup typeĪ full database backup backs up the entire database. Used by DPM/MABS for disk backups, and used in all backups to Azure. With incremental backup, there's no need to supplement with full backups. Inefficient because data blocks that are unchanged between later backups are transferred and stored.Īn incremental backup stores only the blocks of data that changed since the previous backup. Uses a smaller amount of network and storage, and doesn't keep redundant copies of unchanged data. Takes more network bandwidth than differential or incremental backups.Ī differential backup stores the blocks that changed since the initial full backup. The following table explains the different types of backups and when they're used: Backup typeĪ full backup contains the entire data source. Runs on Azure VMs to back them up to a vault. Runs on DPM/MABS servers to back up the DPM/MABS local storage disk to Azure. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |