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