Friday, March 15, 2013

Type of backups in SQL Server

Known all available type of backups in SQL Server. This info will be used later for our backup/restore process.

As far as I know, these are the available type of backup in SQL Server:
 > Full
 > Full with Copy-only option
 > Differential
 > Transaction Log
 > Transaction Log with Copy-only option
 > Partial
 > File
 > Filegroup

There's no incremental backup in SQL Server. Also, incremental and differential backup are not the same.
I'll cover each type of backup in later posts.


No comments:

Post a Comment