This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
public:module:microsoft_sql_database:backup [2019/09/12 15:33] ronnie.chan created |
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 23: | Line 28: | ||
For each of the 2 different backup modes, you can create the following backup set types: | For each of the 2 different backup modes, you can create the following backup set types: | ||
- | ^ ^ VSS Mode ^ ODBC Mode ^ | + | ^ ^ VSS Mode ^ ODBC Mode ^ |
- | ^ Backup Set Types | XXX | XXX | | + | ^ 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. | ||