Skip to main content
BlueXP backup and recovery
All cloud providers
  • Amazon Web Services
  • Google Cloud
  • Microsoft Azure
  • All cloud providers

Restore Microsoft SQL Server workloads with BlueXP backup and recovery

Contributors amgrissino
PDFs

Restore Microsoft SQL Server workloads from snapshot copies, from a workload backup replicated to secondary storage, or from backups stored in object storage using BlueXP backup and recovery. You can restore a workload to the original working environment, to a different working environment that's using the same cloud account, or to an on-premises ONTAP system.

Restore from these locations

You can restore workloads from different starting locations:

  • Restore from a primary location

  • Restore from a replicated resource

  • Restore from an object store backup

Restore to these points

You can restore data to the latest snapshot or to these points:

  • Restore from snapshots

  • Restore to a specific point in time. This is helpful if you know the name and location of the file, and the date when it was last in good shape.

  • Restore to the latest backup

Restore from object storage considerations

If you select a backup file in object storage, and ransomware protection is active for that backup (if you enabled DataLock and Ransomware Protection in the backup policy), then you are prompted to run an additional integrity check on the backup file before restoring the data. We recommend that you perform the scan.

Tip You'll incur extra egress costs from your cloud provider to access the contents of the backup file.

How restoring workloads works

When you restore workloads, the following occurs:

  • When you restore a workload from a backup file, BlueXP backup and recovery creates a new resource using the data from the backup.

  • When you restore from a replicated workload, you can restore the workload to the original working environment or to an on-premises ONTAP system.

    A diagram that shows the flow to restore a resource

  • When you restore a backup from object storage, you can restore the data to the original working environment or to an on-premises ONTAP system.

Restore methods

You can restore workloads using one of the following methods. Typically, choose one of the following methods based on your restore needs:

  • From the Restore page: Use this when you need to restore a resource, but you don't remember the exact name or the location in which it resides, or the date when it was last in good shape. You can search for the snapshot using filters.

  • From the Inventory page: Use this when you need to restore a specific resource from the last week or month — and you know the name and location of the resource, and the date when it was last in good shape. You browse through a list of resources to find the one you want to restore.

Required BlueXP role
Organization admin, Folder or project admin, Backup and Recovery super admin, Backup and Recovery restore admin role. Learn about BlueXP access roles for all services.

Restore workload data from the Restore option

Restore database workloads using the Restore option.

Steps

  1. From the BlueXP backup and restore menu, select Restore.

    A screenshot showing the Restore page.

  2. Select the database that you want to restore. Use the filters to search.

  3. Select the restore option:

    • Restore from snapshots

    • Restore to a specific point in time. This is helpful if you know the name and location of the file, and the date when it was last in good shape.

    • Restore to the latest backup

      A screenshot showing the Restore options.

Restore workloads from snapshots

  1. Continuing from the Restore options page, select Restore from snapshots.

    A list of snapshots appears.

    A screenshot showing the list of snapshots to restore

  2. Select the snapshot you want to restore.

  3. Select Next.

    You'll see destination options next.

    A screenshot showing the Restore Destination details page.

  4. In the Destination details page, enter the following information:

    • Destination settings: Choose whether you want to restore the data to its original location or to an alternate location. For an alternate location, select the host name and instance, enter the database name, and enter the destination path where you want to restore the snapshot.

    • Pre-restore options:

      • Overwrite the database with the same name during restore: During the restore, the original database name is preserved.

      • Retain SQL database replication settings: Keeps the replication settings for the SQL database after the restore operation.

      • Create transaction log backup before restore: Creates a transaction log backup before the restore operation.* Quit restore if transaction log backup before restore fails: Stops the restore operation if the transaction log backup fails.

      • Prescript: Enter the full path for a script that should be run before the restore operation, any arguments that the script takes, and how long to wait for the script to complete.

    • Post-restore options:

      • Operational, but unavailable for restoring additional transaction logs. This brings the database back online after transaction log backups are applied.

      • Non-operational, but available for restoring additional transaction logs. Maintains the database in a non-operational state after the restore operation while restoring transaction log backups. This option is useful for restoring additional transaction logs.

      • Read-only mode and available for restoring additional transaction logs. Restores the database in a read-only mode and applies transaction log backups.

      • Postscript: Enter the full path for a script that should be run after the restore operation and any arguments that the script takes.

  5. Select Restore.

Restore to specific point in time

BlueXP backup and recovery uses logs and the most recent snapshots to create a point-in-time restore of your data.

  1. Continuing from the Restore options page, select Restore to specific point in time.

  2. Select Next.

    A screenshot showing the Restore to a specific point in time page

  3. In the Restore to a specific point in time page, enter the following infomation:

    • Date and time for data restoration: Enter the exact date and time of the data that you want to restore. This date and time is from the Microsoft SQL Server Database host.

  4. Select Search.

  5. Select the snapshot that you want to restore.

  6. Select Next.

  7. In the Destination details page, enter the following infomation:

    • Destination settings: Choose whether you want to restore the data to its original location or to an alternate location. For an alternate location, select the host name and instance, enter the database name, and enter the destination path.

    • Pre-restore options:

      • Preserve original database name: During the restore, the original database name is preserved.

      • Retain SQL database replication settings: Keeps the replication settings for the SQL database after the restore operation.

      • Prescript: Enter the full path for a script that should be run before the restore operation, any arguments that the script takes, and how long to wait for the script to complete.

    • Post-restore options:

      • Operational, but unavailable for restoring additional transaction logs. This brings the database back online after transaction log backups are applied.

      • Non-operational, but available for restoring additional transaction logs. Maintains the database in a non-operational state after the restore operation while restoring transaction log backups. This option is useful for restoring additional transaction logs.

      • Read-only mode and available for restoring additional transaction logs. Restores the database in a read-only mode and applies transaction log backups.

      • Postscript: Enter the full path for a script that should be run after the restore operation and any arguments that the script takes.

  8. Select Restore.

Restore to the latest backup

This option uses the latest full and log backups to restore your data to the last good state. The system scans logs from the last snapshot to the present. The process tracks changes and activities to restore the most recent and accurate version of your data.

  1. Continuing from the Restore options page, select Restore to the latest backup.

    BlueXP backup and recovery shows you the snapshots that are available for the restore operation.

    A screenshot showing the Restore to latest state page

  2. In the Restore to the latest state page, select the snapshot location of local, secondary storage, or object storage.

  3. Select Next.

  4. In the Destination details page, enter the following infomation:

    • Destination settings: Choose whether you want to restore the data to its original location or to an alternate location. For an alternate location, select the host name and instance, enter the database name, and enter the destination path.

    • Pre-restore options:

      • Overwrite the database with the same name during restore: During the restore, the original database name is preserved.

      • Retain SQL database replication settings: Keeps the replication settings for the SQL database after the restore operation.

      • Create transaction log backup before restore: Creates a transaction log backup before the restore operation.

      • Quit restore if transaction log backup before retore fails: Stops the restore operation if the transaction log backup fails.

      • Prescript: Enter the full path for a script that should be run before the restore operation, any arguments that the script takes, and how long to wait for the script to complete.

    • Post-restore options:

      • Operational, but unavailable for restoring additional transaction logs. This brings the database back online after transaction log backups are applied.

      • Non-operational, but available for restoring additional transaction logs. Maintains the database in a non-operational state after the restore operation while restoring transaction log backups. This option is useful for restoring additional transaction logs.

      • Read-only mode and available for restoring additional transaction logs. Restores the database in a read-only mode and applies transaction log backups.

      • Postscript: Enter the full path for a script that should be run after the restore operation and any arguments that the script takes.

  5. Select Restore.

Restore workload data from the Inventory option

Restore database workloads from the Inventory page.
Using the Inventory option, you can restore only databases, not instances.

Steps

  1. From the BlueXP backup and restore menu, select Inventory.

  2. Choose the host where the resource that you want to restore is located.

  3. Select the Actions Actions icon icon, and select View details.

  4. On the Microsoft SQL Server page, select the Databases tab.

  5. On the Databases tab, select the database that shows a "Protected" status indicating that there's a backup that you can restore.

    A screenshot showing the Inventory page and Databases tab

  6. Select the Actions Actions icon icon, and select Restore.

    The same three options appear as when you restore from the Restore page:

    • Restore from snapshots

    • Restore to a specific point in time

    • Restore to the latest backup

  7. Continue with the same steps for the restore option from the Restore page

    A screenshot showing the Restore options.