04 July 2009

🛢DBMS: Incremental Backup (Definitions)

"Backups that only copy objects that have changed since the last backup." (Tom Petrocelli, "Data Protection and Information Lifecycle Management", 2005)

"A database backup containing only the data that has changed since the last full backup or incremental copy was made." (Craig S Mullins, "Database Administration", 2012)

"A backup that saves files that have changed since the last backup. When data is backed up, the archive bit on a file is turned off, and when changes are made to the file, the archive bit is set again. An incremental backup uses this information to only back up files that have changed since the last backup. An incremental backup turns the archive bit off again, and the next incremental backup backs up only the files that have changed since the last incremental backup. This sort of backup saves time, but it means that the restore process will involve restoring the last full backup and every incremental backup made after it." (Mark Rhodes-Ousley, "Information Security: The Complete Reference, Second Edition, 2nd Ed.", 2013)

"A backup operation that backs up all files that have the archive attribute set to On and then sets the attribute to Off." (Faithe Wempen, "Computing Fundamentals: Introduction to Computers", 2015)

"A copy of all database data that has changed since the most recent successful full backup operation. An incremental backup is also known as a cumulative backup image because each incremental backup includes the contents of the previous incremental backup." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.