Friday, March 15, 2013

Type of backups in SQL Server

Goals:
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

Note:
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.

Credits:
http://msdn.microsoft.com/en-us/library/ms186865(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms179401(v=sql.105).aspx
https://www.simple-talk.com/sql/backup-and-recovery/partial-backup-and-restore/
http://msdn.microsoft.com/en-us/library/ms191495.aspx

No comments:

Post a Comment