public:module:microsoft_sql_database:backup
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:module:microsoft_sql_database:backup [2019/09/12 15:34] ronnie.chan |
public:module:microsoft_sql_database:backup [2019/09/19 18:00] (current) ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Performing Backup for Microsoft SQL Server ====== | ====== Performing Backup for Microsoft SQL Server ====== | ||
| - | Creating Backup Set for Microsoft SQL Server | + | ---- |
| + | |||
| + | {{INLINETOC}} \\ | ||
| + | |||
| + | ===== Creating Backup Set for Microsoft SQL Server ===== | ||
| + | ---- | ||
| 1. Click the Backup Sets icon on the main interface of CloudBacko Pro. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_013.png?200}} | 1. Click the Backup Sets icon on the main interface of CloudBacko Pro. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_013.png?200}} | ||
| Line 10: | Line 15: | ||
| * **Name** – enter a meaningful backup set name | * **Name** – enter a meaningful backup set name | ||
| * **Backup mode** – choose between VSS mode and ODBC mode. Refer to the Backup Mode section for details on the differences between the two modes. | * **Backup mode** – choose between VSS mode and ODBC mode. Refer to the Backup Mode section for details on the differences between the two modes. | ||
| - | * **Server** - AhsayOBM supports backup of multiple SQL instance in one backup set. In this Server drop-down menu, you can choose to back up multiple SQL instances or a specific instance of your choice. | + | * **Server** - CloudBacko Pro supports backup of multiple SQL instance in one backup set. In this Server drop-down menu, you can choose to back up multiple SQL instances or a specific instance of your choice. |
| * **Login** - Enter the login ID for the chosen instance. | * **Login** - Enter the login ID for the chosen instance. | ||
| * Password – Enter the password for the chosen instance. | * Password – Enter the password for the chosen instance. | ||
| Line 25: | Line 30: | ||
| ^ ^ VSS Mode ^ ODBC Mode ^ | ^ ^ VSS Mode ^ ODBC Mode ^ | ||
| ^ Backup Set Types | 1. Full \\ 2. Differential \\ 3. Incremental | 1. Full \\ 2. Differential \\ 3. Transaction Log | | ^ Backup Set Types | 1. Full \\ 2. Differential \\ 3. Incremental | 1. Full \\ 2. Differential \\ 3. Transaction Log | | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_016.png?640}} | ||
| + | |||
| + | Differnent backup set types are explain in Appendix A. | ||
| + | |||
| + | 6. In the Destination menu, select a backup destination where the backup database will be stored. Click the “+” icon next to Add new storage destination / destination pool. | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_017.png?640}} | ||
| + | |||
| + | 7. Select the destination storage, then click OK to proceed. | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_018.png?640}} | ||
| + | |||
| + | For more information regarding backing up to cloud storage destination, refer to Appendix C Cloud Storage as Backup Destination. | ||
| + | |||
| + | 8. Click Next on the Destination menu page to proceed. | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_019.png?640}} | ||
| + | |||
| + | 9. In the Encryption window, the default Encrypt Backup Data option is enabled with an encryption key preset by the system which provides the most secure protection. | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_020.png?640}} | ||
| + | |||
| + | You can choose from one of the following 2 Encryption Type options: | ||
| + | |||
| + | * **Default** – an encryption key with 44 alpha numeric characters will be randomly generated by the system | ||
| + | |||
| + | * **Custom** – you can customize your encryption key, where you can set your own algorithm, encryption key, method and key length. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_021.png?640}} | ||
| + | |||
| + | 10. If you have enabled the Encryption Key feature in the previous step, the following pop-up window shows, no matter which encryption key you have selected. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_022.png?640}} | ||
| + | |||
| + | The pop-up window has the following three options to choose from: | ||
| + | |||
| + | * **Unmask encryption key** – The encryption key is masked by default. Click this option to show the encryption key. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_023.png?640}} | ||
| + | |||
| + | * **Copy to clipboard** – Click to copy the encryption key, then you can paste it in another location of your choice. | ||
| + | |||
| + | * **Confirm** – Click to exit this pop-up window and proceed to the next step. | ||
| + | |||
| + | 11. Enter the Windows login credentials for user authentication. Click Next to proceed. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_024.png?640}} | ||
| + | |||
| + | <WRAP info>This screen shows only if you have configured scheduled backup.</WRAP> | ||
| + | |||
| + | 12. The following screen shows when the new backup set is created successfully. | ||
| + | |||
| + | {{public:module:microsoft_sql_database:cloudbacko_module_sql_025.png?640}} | ||
| + | |||
| + | 13. Click Backup now to start a backup immediately, or you can run a backup job later by following the instructions in Running Backup Job for Microsoft SQL Server. | ||
| + | |||
| + | \\ | ||
| + | |||
| + | ===== Running Backup Job for Microsoft SQL Server ===== | ||
| + | ---- | ||
| + | |||
| + | 1. Click the Backup icon on the main interface of CloudBacko Pro. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_026.png?200}} | ||
| + | |||
| + | 2. Select the backup set which you would like to start a backup for. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_027.png?640}} | ||
| + | |||
| + | 3. Select the Backup set type. For more details regarding the Backup set type & In-file delta type, refer to Appendix A Backup Set Type. | ||
| + | |||
| + | * For VSS Backup Mode \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_028.png?640}} | ||
| + | |||
| + | * For ODBC Backup Mode \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_029.png?640}} | ||
| + | |||
| + | If you would like to modify the In-File Delta type (for Full backup set type only), Destinations and Retention Policy settings, click **Show advanced option**. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_030.png?640}} | ||
| + | |||
| + | 5. Click Backup to start the backup. | ||
| + | |||
| + | \\ | ||
| + | |||
| + | ===== Configuring Backup Schedule for Automated Backup ===== | ||
| + | ---- | ||
| + | |||
| + | 1. Click the **Backup Sets** icon on the CloudBacko Pro main interface. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_031.png?200}} | ||
| + | |||
| + | 2. Select the backup set that you want to create a backup schedule for. | ||
| + | |||
| + | 3. Click **Backup Schedule**, then create a new backup schedule by clicking **Add**. | ||
| + | |||
| + | 4. Configure the backup schedule settings, then click **OK** to proceed. | ||
| + | |||
| + | 5. Click **Save** to confirm your settings. | ||
public/module/microsoft_sql_database/backup.1568273682.txt.gz · Last modified: 2019/09/12 15:34 by ronnie.chan
Page Tools
