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:39] 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 57: | Line 62: | ||
| The pop-up window has the following three options to choose from: | 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. | + | |
| + | * **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. | + | * **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. | + | |
| + | * **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. | + | 11. Enter the Windows login credentials for user authentication. Click Next to proceed. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_024.png?640}} |
| - | Note: This screen shows only if you have configured scheduled backup. | + | |
| + | <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. | + | 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. | + | 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.1568273973.txt.gz · Last modified: 2019/09/12 15:39 by ronnie.chan
Page Tools
