public:module:microsoft_sql_database:appendix_a
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
public:module:microsoft_sql_database:appendix_a [2019/09/13 12:10] ronnie.chan created |
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 14: | 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}} | ||
| - | A differential backup of the SQL server saves changes to the database that have occurred since the last full backup. To perform a differential backup, AhsayOBM requests the SQL server to generate a differential backup file of the database since the last full backup. At the back end, the SQL server performs the following: | + | A differential backup of the SQL server saves changes to the database that have occurred since the last full backup. To perform a differential backup, CloudBacko Pro requests the SQL server to generate a differential backup file of the database since the last full backup. At the back end, the SQL server performs the following: |
| - Generate a VSS snapshot of the database of the current state. | - Generate a VSS snapshot of the database of the current state. | ||
| - Compare the VSS snapshot just generated by the SQL server with the one generated from the last full backup in order to produce a differential backup file. | - Compare the VSS snapshot just generated by the SQL server with the one generated from the last full backup in order to produce a differential backup file. | ||
| - | - The differential backup file being sent to AhsayOBM for backup. | + | - The differential backup file being sent to CloudBacko Pro for backup. |
| Using a differential backup file to recover a database requires the restoration of only two data sets - the last full backup and the most recent differential backup. | Using a differential backup file to recover a database requires the restoration of only two data sets - the last full backup and the most recent differential backup. | ||
| Line 32: | 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 50: | 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.1568347847.txt.gz · Last modified: 2019/09/13 12:10 by ronnie.chan
Page Tools
