Skip to main content

Create a Backup Set


Creating a Microsoft SQL Backup Set

  1. Click the Backup Sets icon on the main interface of AhsayOBM.

    success

  2. Create a new backup set by clicking the "+" icon beside "Add new backup set".

    success

  3. Select the "Bacup set type" which is MS SQL Server Backup.

    success

    • 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.
    • 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.
    • Authentication - AhsayOBM supports two authentication types when creating a Backup Set for MS SQL: SQL Server Authentication and Windows Authentication.
    • Login ID - Enter the login ID for the chosen instance.
    • Password - Enter the password for the chosen instance.

    Click Next to proceed when you are done with the settings.

    The Login ID and Password fields are removed if the user has selected Windows User Authentication as the Authentication type. If the user has selected SQL Server Authentication, a valid Login ID and Password must be input into their respective fields in order to not encounter any errors in step 11.

  4. In the "Backup Source" menu, select the database you would like to back up, then click Next to proceed.

    success

  5. In the "Schedule" menu, you can configure a backup schedule for backup job to run automatically at your specified time interval. Click Add to add a new schedule, then click Next to proceed when you are done with the settings.

    success

    For details on how to configure the backup schedule settings, please refer to the Overview section.

     VSS ModeODBC Mode
    NameName of the Backup Schedule
    Backup set type
    • Full
    • Full
    • Differential
    • Transaction Log
    Refer to Troubleshooting - Backup Set Type for details on the differences of the backup set type.
    TypeChoose frequency for this backup schedule to occur
    Start backupChoose a specific time or interval for this backup schedule to start
    StopChoose when backup will stop, only applies to schedules with start backup “at” and is not supported for periodic backup schedule (start backup “every”)
    Run Retention Policy after backupCheck this box if you wish to enable the Retention Policy setting.
  6. In the “Destination” menu, select a backup destination where the backup database will be stored. Click the "+" icon beside "Add new storage destination / destination pool".

    success

  7. Select the "Destination storage", then click OK to proceed.

    success

    For more information regarding backing up to cloud storage destination, refer to Troubleshooting - Cloud Storage as Backup Destination.

  8. Click Next on the "Destination" menu page to proceed.

    success

  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. Click Next when you are done settings.

    success

  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.

    success

    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.
    • 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. In the Windows User Authentication page, the switch for turning Windows Authentication on or off will only be accessible if users selected SQL Server Authentication in step 3.

    success

    If this option is turned on, and the authentication type selected is SQL Server Authentication, the Windows credentials entered on this page will be the first used by AhsayOBM for authentication. Toggling this switch off will cause the fields for Domain Name, User name, and Password to be greyed out.

    When attempting to switch the setting off, this message will be displayed:

    success

    If the user selects Yes, AhsayOBM will attempt to login to the SQL Server with SQL Server Authentication using the credentials that were specified in step 3. If the details are invalid, the user will be met with an error, prompting them to input a valid Login ID and Password.

  12. The following screen shows when the new backup set is created successfully.

    success

  13. Click Backup now to start a backup immediately, or you can run a backup job later by following the instructions in Run Backup Job for Microsoft SQL Server.
  14. Based on Best Practices and Recommendations, it is highly recommended to set the “Temporary Directory” to another location other than Drive C: (e.g. Drive D:).

    Go to Others>Temporary Directory and click the Change button to browse for another location.

    success

  15. Optional: Select your preferred compression type. By default, the compression type is Fast with optimization for local.

    Go to Others>Compressions, then select from the following:

    • No Compression
    • Normal
    • Fast (Compressed size larger than normal)
    • Fast with optimization for local

    success