[dba-SQLServer] Database backups

On 25 Feb 2012 at 11:46, jwcolby wrote:

> How does an incremental database backup work?  I kinda have a picture in my head, only the changed 
> stuff is backed up, 

Correct, 

> to the same file (maybe?) and so forth.  Not even sure if that is true.

Normally to separate files

> What about restores from?  Is the entire thing restored?  Only changes from a specific date / time?
> 

You have to restore the last full backup AND THEN every subsequent incremental backup in 
order.