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:48] 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 ====== | ||
- | |||
---- | ---- | ||
+ | |||
+ | {{INLINETOC}} \\ | ||
===== Creating Backup Set for Microsoft SQL Server ===== | ===== 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 13: | 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 77: | Line 79: | ||
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 ===== | ===== 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}} | 1. Click the Backup icon on the main interface of CloudBacko Pro. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_026.png?200}} | ||
Line 95: | Line 98: | ||
5. Click Backup to start the backup. | 5. Click Backup to start the backup. | ||
- | ---- | + | \\ |
===== Configuring Backup Schedule for Automated Backup ===== | ===== Configuring Backup Schedule for Automated Backup ===== | ||
+ | ---- | ||
- | 1. Click the **Backup Sets** icon on the AhsayOBM main interface. \\ {{public:module:microsoft_sql_database:cloudbacko_module_sql_031.png?200}} | + | 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. | 2. Select the backup set that you want to create a backup schedule for. |