public:module:microsoft_sql_database:appendix_a
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
public:module:microsoft_sql_database:appendix_a [2019/09/19 18:03] ronnie.chan |
public:module:microsoft_sql_database:appendix_a [2019/09/19 18:04] (current) ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Appendix A: Backup Set Types for MS SQL Backup Set ====== | ====== Appendix A: Backup Set Types for MS SQL Backup Set ====== | ||
| ---- | ---- | ||
| + | |||
| There are four kinds of backup set type to choose from, namely full backup, differential backup, incremental backup and transaction log backup. The information below gives you an overall idea of what each backup set type is like. | There are four kinds of backup set type to choose from, namely full backup, differential backup, incremental backup and transaction log backup. The information below gives you an overall idea of what each backup set type is like. | ||
| - | ---- | + | {{INLINETOC}} \\ |
| - | ===== 1). Full backup (with configurable in-file delta type) ===== | + | ===== Full backup (with configurable in-file delta type) ===== |
| + | ---- | ||
| {{public:module:microsoft_sql_database:cloudbacko_module_sql_042.png?640}} | {{public:module:microsoft_sql_database:cloudbacko_module_sql_042.png?640}} | ||
| Line 15: | Line 17: | ||
| For further details on this topic, refer to this URL: [[https://msdn.microsoft.com/en-us/library/ms175477.aspx]] | For further details on this topic, refer to this URL: [[https://msdn.microsoft.com/en-us/library/ms175477.aspx]] | ||
| - | ---- | + | \\ |
| - | ===== 2). Differential backup ===== | + | ===== Differential backup ===== |
| + | ---- | ||
| {{public:module:microsoft_sql_database:cloudbacko_module_sql_043.png?640}} | {{public:module:microsoft_sql_database:cloudbacko_module_sql_043.png?640}} | ||
| Line 33: | Line 36: | ||
| For further details on this topic, refer to this URL: [[https://msdn.microsoft.com/en-us/library/ms186289.aspx]] | For further details on this topic, refer to this URL: [[https://msdn.microsoft.com/en-us/library/ms186289.aspx]] | ||
| + | \\ | ||
| + | |||
| + | ===== Incremental backup ===== | ||
| ---- | ---- | ||
| - | |||
| - | ===== 3). Incremental backup ===== | ||
| {{public:module:microsoft_sql_database:cloudbacko_module_sql_044.png?640}} | {{public:module:microsoft_sql_database:cloudbacko_module_sql_044.png?640}} | ||
| Line 51: | Line 55: | ||
| The disadvantage of using incremental backups is that if there are many incremental backups made between full backups, recovering the storage group may involve recovering many incremental backups. The SQL server does not allow an incremental backup to occur when there has been no previous full backup to establish the starting point. | The disadvantage of using incremental backups is that if there are many incremental backups made between full backups, recovering the storage group may involve recovering many incremental backups. The SQL server does not allow an incremental backup to occur when there has been no previous full backup to establish the starting point. | ||
| - | ---- | + | \\ |
| - | ===== 4). Transaction log backup ===== | + | ===== Transaction log backup ===== |
| + | ---- | ||
| {{public:module:microsoft_sql_database:cloudbacko_module_sql_045.png?640}} | {{public:module:microsoft_sql_database:cloudbacko_module_sql_045.png?640}} | ||
public/module/microsoft_sql_database/appendix_a.1568887416.txt.gz · Last modified: 2019/09/19 18:03 by ronnie.chan
Page Tools
