public:module:microsoft_sql_database:appendix_a
Differences
This shows you the differences between two versions of the page.
| Next revision Both sides next 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/17 16:12] ronnie.chan |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| {{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. | ||
public/module/microsoft_sql_database/appendix_a.txt · Last modified: 2019/09/19 18:04 by ronnie.chan
Page Tools
