[dba-SQLServer] Database backups

Stuart McLachlan stuart at lexacorp.com.pg
Sat Feb 25 15:58:31 CST 2012

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, 


> 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 

More information about the dba-SQLServer mailing list