6. High Availability : Backup and Restore : Hybrid Approach: Full Backup with Incremental Reload
 
Share this page                  
Hybrid Approach: Full Backup with Incremental Reload
To take a full database backup is the easiest way to back up your Vector database. However your database may be terabytes in size and as a result, depending on the hardware you use, taking and restoring the backup may take a long time. A full database backup will also take up a significant amount of storage space.
As an alternative to the use of a full followed by incremental backup, data warehouses commonly use a strategy of a regular (such as weekly or monthly) full database backup and store incremental data loads (data files) until the next full backup. A database restore and recovery consists of restoring the most recent full database backup followed by a replay of the data loads since the most recent full backup.